Jan 21, 2014

Ascent sensitive and insensitive collation example in sql server


In collation name meaning of AI and AS
AI: Ascent insensitive

AS: Ascent sensitive

Example of ascent insensitive comparison in sql server

IF 'a' = 'à' COLLATE Latin1_General_CI_AI
    SELECT 'Ascent insensitive'
ELSE
    SELECT 'Ascent sensitive'   

Output:  Ascent insensitive

Example of ascent insensitive comparison in sql server
   
IF 'a' = 'à' COLLATE Latin1_General_CI_AS
    SELECT 'Ascent insensitive'
ELSE
    SELECT 'Ascent sensitive'  

No comments:

Post a Comment