Hi,

> At 01:57 AM 16/01/2003 +0000, you 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?

> >
> >jw
>
> Not all databases support the enormous range of character sets that
> Firebird does, though, do they? With the exception of Oracle, the others
> are still playing catch-up to Firebird and InterBase in this regard.

Sure thing.

> Firebird DOES have an easy solution to implement case-insensitive
> indexes: you define the index with a case-insensitive collation order.

Eh - what?? I can't find anything that has to do with collation when it
comes to indices?



With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase & Firebird
Firebird Workbench - the developer tool for Firebird
Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."