Subject | How to make a case sensitive comparative with collation unicode_ci_ai |
---|---|
Author | K Z |
Post date | 2012-07-13T00:18:02Z |
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]
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]