更新时间:2022-12-17 23:23:13
可以在各种情况下设置排序规则级别:
Collation can be set at various levels:
因此,您可以在不区分大小写的数据库中包含一个区分大小写的列。我还没有遇到过可以针对单个数据列的大小写敏感性进行业务案例分析的情况,但是我想可能会存在。
So you could have a Case Sensitive Column in a Case Insensitive database. I have not yet come across a situation where a business case could be made for case sensitivity of a single column of data, but I suppose there could be.
检查服务器排序规则
SELECT SERVERPROPERTY('COLLATION')
检查数据库排序规则
SELECT DATABASEPROPERTYEX('AdventureWorks', 'Collation') SQLCollation;
检查列排序规则
select table_name, column_name, collation_name
from INFORMATION_SCHEMA.COLUMNS
where table_name = @table_name