sql server 字符串大小写敏感比较

--方法一，使用varbinary转换再比较
DECLARE
@a varchar(50) = 'XLvmS9k1S3C165b0+eSVMjjPMrc='
,
@b varchar(50) = 'XLvmS9k1S3C165b0+eSVMjjPMrc='

if (cast(@a as varbinary(max))=cast(@b as varbinary(max)) )
BEGIN
    PRINT 'Matched'
END
else
    print 'Un-Matched'
--方法二，在比较字符串时加入 COLLATE 
IF('XLvmS9k1S3C165b0+eSVMjjPMrc=' COLLATE Chinese_PRC_CS_AI='XLvmS9k1S3C165b0+eSVMjjPMrc=')  
    PRINT 'Matched'  
ELSE  
    PRINT 'Un-Matched'