Re[2]: [Firebird-devel] Case-insensitive collations

[Horvath, S. <san...@fr...>]

Hi All!

Please forgive me for my english!

> Hi Alexandre,

>> But then, they have a problem, if they search for
>> like "Alexandre%"
>>
>> he will not macth the legacy records that was imported as "ALEXANDRE"

> It is (in my opinion) a defect in the Firebird code, that
> like "Alexandre%" (and equivalently STARTING WITH "Alexandre")
> doesn't work for you. For every multi-level collation it should matches
> ALEXANDRE and alexandre and Alexandr=E9 etc.

Be carefull with collations! The "alexandre =3D Alexandr=E9" is not so
simple.
Well, in hungarian language this is not right! Firebird 1.5 has a
character set (WIN1250) and a collation (PXW_HUNDC) for hungarian but
it is a mistake. For example:
In hun. alphabet there are letters a=E1b or A=C1B, the order is important
but the case is doesn't matter. Users don't want to press shift to
try to find a name!
Firebird solves this problem the following way: a=3DA, a=3D=E1, a=3D=C1!
This is not good! The order is wrong, becouse "=E1" doesn't follow "a"
and it doesn't work in indexed search but in UPPER().
So I ask, what is the reason that there's no really case-insensitive
national support is Firebird? Maybe this is the weakest point of it!
BTW: I love Firebird! It's the best SQL server! Small, simple and
powerfull...

Sandor