SQL SERVER 的排序规则说明_sql server中的排序规则说明-优快云博客

本文介绍了SQL Server中排序规则(SQL Collation)的相关概念及其使用方法，包括如何查询当前数据库的默认排序规则、解释特定排序规则（如'SQL_Latin1_General_CP1_CI_AI'）的含义，并提供了检查表中特定列排序规则的方法。

Version: 2008

SELECT SERVERPROPERTY('Collation') --check the default orderof current database

SELECT * FROM ::fn_helpcollations() where name = 'SQL_Latin1_General_CP1_CI_AI'-- explanation of 'SQL_Latin1_General_CP1_CI_AI'

SELECT collation FROMsyscolumns whereid=object_id(N'tablename') ---check the default order of table ‘pick_list’ columns

Explanation of 'SQL_Latin1_General_CP1_CI_AI': CP1 specifies code page 1252, CIspecifies case-insensitive, AI specifies accent-insensitive

Explanation of Code Page and Windows-1252:

COLLATE: http://msdn.microsoft.com/en-us/library/aa258237%28v=sql.80%29.aspx

SQL Collation Name : http://technet.microsoft.com/en-us/library/aa258233%28v=sql.80%29.aspx

Windows Collation Designators : http://technet.microsoft.com/en-us/library/aa176553%28v=sql.80%29.aspx

排序规则相关帖子： http://bbs.youkuaiyun.com/topics/380194117