Martijn,

> > 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?
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).
Ciao
--
____
_/\/ando