> 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.

>Collation UNICODE_CI_AI is by definition case insensitive, that is what the CI stands for in the collation name. >You either need to use collation UNICODE, or one of the other available case sensitive collations, or you need to
>create a specific collation.

select * from USERS where password collate unicode = 'wOrD';

Though I think using COLLATE like this means that indexes (except expression indexes) cannot be used.

HTH,
Set