SQL SERVER 編碼

SQL SERVER各種欄位型態編碼

select data_type, character_set_catalog, character_set_schema, character_set_name,collation_catalog, collation_schema, collation_name, count(*) count from information_schema.columns group by data_type, character_set_catalog, character_set_schema, character_set_name,collation_catalog, collation_schema, collation_name;

編碼說明(In SQL SERVER)

• Big5(cp950) : 中文字占 2Byte 
• Unicode(UTF-16) : 中文字占 2Byte
• UTF-8 : 中文字占 3Byte 

例:
varchar(2) : 2Byte，可放1個中文字
nvarchar(2) : 4Byte，可放2個中文字