MS SQL when inserting Chinese characters. Often encounter some of the characters become garbled question mark, so in the installation of the database or in the creation of the table need to pay attention to a few points:
1, Save the field of Chinese characters to use nvarchar, NCHAR, ntext and so on. Use n ' kanji ' when inserting
2, when installing the database, select the Chinese_prc_ci_as collation, assuming that the other collation can be changed by such as the following:
Database name Right-click Properties, Options, collation, select as Chinese_prc_ci_as
Here's my database server collation: I can see that 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. For example, as seen 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