SQL Server Chinese garbled explanation ~

server| Chinese | Chinese garbled

Run sp_help "Your table" to get the collation setting for the column. In order to store Chinese correctly, your should set the collation be:
Chinese_prc_ci_as
or chinese_stoke_ci_as

Char/varchar data type is ANSI char which must define a code page. If you set the collation is sql_latin1_general_cp_ci_as, it can only store Latin characters. In an order to store Chinese character in a char column, your have to set the collation is Chinese_prc_ci_as or Chinese_stok E_ci_as which has a Chinese code page defined.

Nchar/nvarchar Collumn is different, your can store any Unicode character include Enlish, Chinese, Japanese in one column.

In term of input Chinese character, the character constant would use database ' s collation. Thus, if the database ' s collation is not Chinese collation, there are no way to input Chinese char/varchar data, such as
' Chinese ' would be treated as '?? '. But for Nvarchar/ncar, can input it
On any collation. such as N ' Chinese ' would be treated as two Unicode chars