LocalDB database Modify collation, fix Chinese character change question mark

vs2012,vs2013 new Lightweight database localdb, with this, developers will no longer have to install a large SQL server, can easily test running small projects, since it is a lightweight database, it abandoned a large body, of course, will also be limited in function, One of them is its default collation, using the default collation, the Chinese data added from the Web site foreground display garbled or variable question marks in the database; This problem troubled me for several days, through a variety of search, finally found a solution; I would like to help you with the same confusion!
1. Right-click DB instance, new query modifies database to single user mode

ALTER DATABASE [DB name or full path] set Single_user with rollback immediate;
Go

2. Modify the collation ( Chinese--Pinyin--not case sensitive)

ALTER DATABASE [DB name or full path] collate chinese_prc_ci_as;
Go

3. Reset to multi-user mode

ALTER DATABASE [DB name or full path] set Multi_user;

Where the collation name is composed of two parts, the first half refers to the character set supported by this collation.
Such as:
Chinese_prc_cs_ai_ws
First half: Refers to the Unicode character set, chinese_prc_ the pointer to the mainland simplified Unicode collation. The second half of the collation is the suffix meaning:

_bin binary Ordering

_ci (CS) is case sensitive, CI is not differentiated, CS is case sensitive: Select this option if you want comparisons to treat uppercase and lowercase letters as unequal.

_ai (AS) is accent-sensitive, AI is not differentiated, as is accent sensitive: Select this option if you want the comparison to treat accented and non-accented letters as unequal. If you select this option, the comparison also treats letters with different accents as unequal.

_ki (KS) Whether the kana type is differentiated, KI does not differentiate, KS differentiates kana: Select this option if you want the comparison to treat katakana and hiragana Japanese syllables as unequal.

_WI (WS) Whether the width of the WI is not differentiated, the WS differentiates the width: Select this option if you want the comparison to treat half-width characters and full-width characters as unequal

LocalDB database Modify collation, fix Chinese character change question mark