SQL Server provides a wide range of Windows and SQL Server-specific collations

Initial selection Results

SELECT * FROM Worddictionary

The following is the alphabetical order by Chinese characters

SELECT * from Worddictionary ORDER by word collate chinese_prc_cs_as_ks_ws

which

_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

SQL Server provides a wide range of Windows and SQL Server-specific collations