Hi,

> > > 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?
>
> actually you define the _field_ with a case-insensitive collation order.
> Or you may embed a collate clause into an order by clause I believe.
> Perhaps even into a where clause?

Dunno :)

I can't find a clear list of case insensitive collation orders, let alone if
they work for a WHERE clause as well.

> I don't think it's possible to link a particular index with a particular
> collection, nor is this desirable (and Ann has explained why).

Well, if you have the _option_ - it might be desirable sometimes :)


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."