SQL case-sensitive comparison over MySql
If someone is finding a way to do a case sensitive comparison in SQL (over MySql), below can find the recipe:
This one produces a True result:
1
SELECT ‘A’ = ‘a’;
The solution is doing the comparison with a = or LIKE and the BINARY clause:
2
SELECT ‘A’ LIKE BINARY ‘a’;
or
3
SELECT ‘A’ = BINARY ‘a’;
This produces a False result [...]
