MS SQL when inserting Chinese characters, often encounter some of the characters into a garbled question mark, so in the installation of the database or when creating a table need to pay attention to a few points:
1, the preservation of the Chinese character field to use nvarchar, NCHAR, ntext, etc., insert the time to use n ' Kanji '
2, when installing the database, select the Chinese_prc_ci_as collation, if the other collation can be modified by the following:
Database name Right-click Properties, Options, collation, select as Chinese_prc_ci_as
Here's my database server collation: As you can see, it's chinese_hong_kong_stroke_90_ci_as.
U
Because my database server collation is: chinese_hong_kong_stroke_90_ci_as, so my server will appear garbled characters of the situation, as shown in:
1,select ' Ceramic tile tile '
From the above can be seen garbled
2,select N ' Ceramic tile tile '
As can be seen from the above, the normal display. In other words , use n ' kanji ' when inserting
SQL 2012 English garbled