SQL 2012 English garbled

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