Subject RE: [firebird-support] How to make a case sensitive comparative with collation unicode_ci_ai
Author Svein Erling Tysvær
> 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.