In collation name meaning of CI and
CS
CI: Case
insensitive
CS: Case
sensitive
Example of case insensitive comparison in sql server
IF 'a' = 'A' COLLATE
Latin1_General_CI_AI
SELECT 'Case insensitive'
ELSE
SELECT 'Case sensitive'
Output: Case insensitive
Example of case insensitive comparison in sql server
IF 'a' = 'A' COLLATE
Latin1_General_CS_AI
SELECT 'Case insensitive'
ELSE
SELECT 'Case sensitive'
No comments:
Post a Comment