Collate

可应用于数据库定义或列定义以定义排序规则，或应用于字符串表达式以应用排序规则转换。

 

可以执行系统函数 fn_helpcollations来检索 Windows 排序规则和 SQL Server 排序规则的所有有效排序规则名称的列表：

 

SELECTname, description

FROMfn_helpcollations();

 

CREATE TABLELocations

(Place varchar(15)NOT NULL);

GO

INSERTLocations(Place) VALUES ('Chiapas'),('Colima')

                             , ('Cinco Rios'),('California');

GO

--Apply an typicalcollation

SELECT Place FROMLocations

ORDER BY Place

COLLATELatin1_General_CS_AS_KS_WS ASC;

GO

-- Apply a Spanishcollation

SELECT Place FROMLocations

ORDER BY Place

COLLATETraditional_Spanish_ci_ai ASC;

GO