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:
http://en.wikipedia.org/wiki/Code_page
http://en.wikipedia.org/wiki/Windows-1252
http://technet.microsoft.com/en-us/library/aa176553%28v=sql.80%29.aspx
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.csdn.net/topics/380194117