SQL Server garbled Problem resolution

* If you are creating a database of your own then you should choose the collation from the beginning:chinese_prc_ci_as

1. Change the collation method:

Right click Gen built database, properties → options → sort rule selected: chinese_prc_ci_as

If you select chinese_prc_ci_as The data is still garbled when it is found, or when data is inserted,

That's because the default collation when creating a database is sql_latin1_general_cp1_ci_as Reason for span style= "color: #000000",

You can change the type of the field at this time, reinsert the data or resolve garbled problem.

But the best way is to choose when you create the database :chinese_prc_ci_as collation

2. The second method is the most direct of the most brain-free

If a database is found to be garbled, the collation alsoChinese_prc_ci_as similar to , most of the data is normal and individual data garbled,

Then the data can be directly update back, the situation is just right for me to meet the problem today.

┄┅┄┅┄┅┄┅┄°┄┅┄┅┄┅┄┅┄°┄┅┄┅┄┅┄┅┄°┄┅┄┅┄┅┄┅┄°┄┅┄┅┄┅┄┅┄°┄┅┄┅┄┅┄┅┄°

chinese_prc_ci_asThe 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.
differentiate Accent: 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.
< Span style= "color: #454545; font-family: "pingfang sc","microsoft Yahei", Simhei, Arial, SimSun "> Kana-sensitive: If you want to compare katakana and hiragana Japanese syllables as unequal , select this option.
< Span style= "color: #454545; font-family: "pingfang sc","microsoft Yahei", Simhei, Arial, SimSun "> width: If you want the comparison to treat half-width characters and full-width characters as unequal, Please select this option.

┄┅┄┅┄┅┄┅┄°┄┅┄┅┄┅┄┅┄°┄┅┄┅┄┅┄┅┄°┄┅┄┅┄┅┄┅┄°┄┅┄┅┄┅┄┅┄°┄┅┄┅┄┅┄┅┄°

If there are deficiencies, please correct me!

SQL Server garbled Problem resolution