SQL Server 6.5之前不支援雙位元字(DBCS Code Page),需手動安裝 DBCS Code Page
SQL Server7.0之後才支援Unicode
Default code page for SQL Server:
https://support.microsoft.com/en-us/kb/153449
SQL Server 4.21a => code page 850 (Multilingual)
SQL Server 6.0 and 6.5 => ISO 8859-1 (Latin 1 or ANSI), 也就是 code page 1252
DBCS(double-byte character set) code page:cp-932、cp-936、cp-949、cp-950
Local LCID Code Page
--------------------------------------------
Chinese (PRC) 0x0804 936
Chinese (Taiwan) 0x0404 950
Chinese (Hong Kong) 0x0c04 950
Chinese (Singapore) 0x1004 936
Japanese 0x0411 932
Korean 0x0412 949
INF: Installing a DBCS Code Page for SQL Server
http://www.c-bit.org/kb/165051/EN-US/
SQL Server處理Unicode字串時,前置詞"N"之使用
http://eportfolio.lib.ksu.edu.tw/~A093000085/blog?node=000000009
沒有留言:
張貼留言