MS SQL Server的nchar(1)列不区分大小写

Question

我在MS SQL Server上运行此代码：

select  * 
from    information_schema.columns 
where   table_name = 'prod__lookup_api'
select  *
from    prod__lookup_api    as a
where   a.code = 'c'    AND
a.code = 'C'

我得到了这些结果。

Answer 1

ok：CI排序规则：Greek_CI_AS。