| Subject | Is diacritic sensitive comparison possible database with UTF8 character set |
|---|---|
| Author | vincent_kwinsey |
| Post date | 2013-03-20T10:51:47Z |
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?
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?