Solve the problem of MSSQL for Linux Chinese garbled

What is called cue unravelling, this is, finally installed completed, in the use of the time incredibly garbled, is a headache, but still solve the problem of the egg, in Windows use MSSQL so long, never appeared in Chinese garbled situation, the specific reason is appearing in SQL Server installation configuration, default installation, the system default collation when the Latin collation, in the installation process has never been noticed, but how to configure in CentOS I do not know, I can only be configured in the MSSQL client windows, the workaround:

When you create a database, you specify the collation of the database as Chinese Simplified (CHINESE_PRC_CS_AI_WS), and note that if there is data in the database at this time, the operation will fail, so it is recommended that you set the collation at the beginning of the database to avoid trouble. Action steps, right-click Database Properties, tap options, modify collation,

After the setup, the data added will not appear garbled. If it is garbled on Windows like this can be set up, of course, there is a rough way, even if you reinstall the system, reinstall SQL, choose a good collation before installing.

The parameters are explained as follows:
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 distinguished
_ai (AS) are accent-sensitive, AI not differentiated, as differentiated
_ki (KS) Whether the kana type is differentiated, KI does not differentiate, KS differentiates
_WI (WS) Whether the width of the WI is differentiated, WS-Differentiated
Case Sensitivity: Select this option if you want the comparison to treat uppercase and lowercase letters as unequal.
Accent Sensitivity: Select this option if you want to treat accented and non-accented letters as unequal. If you select this option,
Comparisons also treat letters with different accents as unequal.
Kana distinction: Select this option if you want the comparison to treat katakana and hiragana Japanese syllables as unequal.
Width difference: Select this option if you want the comparison to treat half-width characters and full-width characters as unequal

Solve the problem of MSSQL for Linux Chinese garbled