Subject How to make a case sensitive comparative with collation unicode_ci_ai
Author K Z
Hello,

I issue the following command:
alter character set utf8 set default collation unicode_ci_ai

Now i need your help to make a case sensitive comparative like this:

select * from USERS where password='wOrD';

Currently, with this collation the where clause ignores the case of the characters.


Thank you.

[Non-text portions of this message have been removed]