At 01:57 AM 1/16/2003 +0000, jwcanada <jwcanada@...> wrote:

>All major database have the features for case insensivity on indices?
>Why could not Firebird come with an easy solution to implement it? It
>is a pain to create duplicate fields in order to do fast search using
>index especially considering an application to support all major database?

OK, you'd like to know why Firebird/InterBase doesn't support
case insensitivity when "every other" database does. You'll
find the long version of the answer in the archives of the
IB-Architect list on yahoogroups starting in late March 2000.
The short version is that the implementations done by other
databases were crude, interfered with cross database operations,
and produced anomalies such that the transitive property of
equality was lost.

Case insensitive collations are a good solution. We have them -
not for every language, but for a number and, unfortunately not
on every platform. That's a software engineering issue and
can probably be solved.


Regards,

Ann
www.ibphoenix.com
We have answers.