> Are there any case insensitive collations in firebird 1.5 or 2?
> I am wanting to do case insensitive searches. While I can do this with
> Upper, it doesn't use any indexes so it's not very efficient.

With Firebird 1.5 you can create a surrogate 'upper' field and use
before insert or update triggers to maintain it. You can then index
this surrogate field and do a 'case insensitive' search against it.
Not ideal but workable.

With Firebird 2, you can use an expression index. For example, you can
create an index on Upper(Field1) so that the following query will use
that index


select *
from table1
where Upper(field1) = 'HELLO WORLD'

Adam