Subject Re: [firebird-support] How to make a case sensitive comparative with collation unicode_ci_ai
Author Mark Rotteveel
On Thu, 12 Jul 2012 17:18:02 -0700 (PDT), K Z <peixinhosdalua@...>
> 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.