sql: string comparison

Question

I have the following sql code:

if ('aaa' = 'aAa') 
    print 'equals'
else
    print 'not equals'

And it prints equals. Why it's this behavior when the strings are not equals?

As per my knowledge, string comparison is not case sensitive in SQL. — Praveen, Feb 23 '17 at 11:38
You need to learn about string *collations*. Obviously, the default for the database you are using is case-insensitive. — Gordon Linoff, Feb 23 '17 at 11:38
You might've forgot to add the `SQL Server` tag to this question, as it is `CASE INSENSITIVE` which might not be true with the others as like `PostgreSQL` or 'Oracle` — N00b Pr0grammer, Feb 23 '17 at 11:39
Related (sql-server): http://stackoverflow.com/questions/1411161/sql-server-check-case-sensitivity — Tim Schmelter, Feb 23 '17 at 11:39
There is no `IF` in "SQL" (the query language). Which DBMS are you using? — a_horse_with_no_name, Feb 23 '17 at 11:44

score 0 · Accepted Answer · answered Feb 23 '17 at 11:39

0

Use collations :

IF 'aaa' COLLATE Latin1_General_CS_AS = 'aAa' COLLATE Latin1_General_CS_AS
 print 'equals'
else
 print 'not equals'

answered Feb 23 '17 at 11:39

Mansoor

1 Answers1