On 20-3-2013 11:51, vincent_kwinsey wrote:

> I have Firebird 2.1.x database with UTF8 character set, collation is not specified for varchar fields.
>
> It is surprising to see, that varchar comparison is not diacritic sensitive, e.g. both the following selects return rdb$databse row in FB 2.1.x (no row was returned for FB 1.5.x):
> select *
> from rdb$database
> where 'A'='Â'
> select *
> from rdb$database
> where upper('A' collate ucs_basic)=upper('Â' collate ucs_basic).
>
> How to perform diacritic sensitive comparison. Maybe now collation should be created and used in collate clause?

This works as expected (as in: no row returned) on Firebird 2.5. I don't
have a FB 2.1 install handy to test it there, but I would expect it to
work there as well.

Mark
--
Mark Rotteveel