Generally, this is not the case, but sometimes the font encoding method of the database is different from the display encoding method, such as simplified and Traditional Chinese, this is the case where the sorting in the database is incorrect and the displayed sorting is incorrect. However, it may be different. Please analyze it based on your own needs. If you can't find it, please forgive me!
Sorting rulesWhat is a sorting rule? Ms is described as follows: "In
In Microsoft SQL Server 2000, the physical storage of strings is controlled by sorting rules. The sorting rule specifies the bit mode of each character and the rules used to store and compare characters. "
Run the following statement in the query analyzer to obtain all the sorting rules supported by SQL Server.
Select * From: fn_helpcollations ()
The name of a sorting rule consists of two parts. The first half is the character set supported by this sorting rule. For example:
Chinese_prc_cs_ai_ws
First half: the Unicode character set. The chinese_prc _ pointer sorts Unicode in simplified Chinese characters.
The second half of the sorting rule is the suffix meaning:
_ Bin
Binary sorting
_ Ci (CS)
Case Sensitive, CI not differentiated, CS differentiated
_ AI ()
Whether to distinguish accent, ai not differentiated, as differentiated
_ KI (KS)
Whether to distinguish the Kana type, the Ki is not differentiated, and the KS is differentiated
_ Whether wi (WS) is differentiated by width WI and WS
Case Sensitive: select this option if you want to make the comparison between uppercase and lowercase letters different.
Accent differentiation: select this option if you want to treat the comparison as different from the accent and non-accent letters. If this option is selected, the comparison also treats letters with different accents as unequal.
Kana differentiation: select this option if you want to treat Katakana and katakana as different Japanese syllables.
Width differentiation: select this option if you want to make the comparison between halfwidth and fullwidth characters.
Select * From Fanti order by name collate chinese_prc_cs_as_ks_ws
Select * From Fanti order by name collate chinese_prc_ci_as_ks_ws
You can modify SQL statements as needed.