Re: [Firebird-devel] Case-insensitive collations

[Carlos H. C. <fb...@wa...>]

Peter,

PJ> For the majority of application, no-case no-accent collations don't make
PJ> sense, and the 'normal' multi-level collations would fulfill all 
PJ> requirements, if only they are used. As you are mentioning in your parallel
PJ> post, in STARTING WITH and LIKE 'foo%'

Despite the fact that I do not fully understand what you mean with
'multi-level collations', I tend to disagree with you... at last in
Brazil, people are requesting for a long time an accent/case
insensitive collation. Almost everyone here comes from the xBase world
where we had case-insensive indexes and this feature is really missed
by those users.

Even an unoficial special Firebird binary was created by a brazilian
guy just to implement a case-insensitive collate called PT_BR. Dave
was contacted some years ago to develop an official case/accent
insensitive collation based on WIN1252 and ISO8859_1. Many people here
contributed with money to pay him for this, but due to lack time (from
him) the work wasn't done.

It seems that FB suffers a collation/charset general mess and I think
it deserves a good cleanup in this area.

In the results of my "Firebird Users Wish List Survey" running at
http://infopoll.net/live/surveys/s25748.htm, this feature is among the
top 4 mostly wanted features. The final results will be published next
week.

[]s
Carlos
http://www.warmboot.com.br
FireBase - http://www.FireBase.com.br