Subject Re: [ib-support] Case insensitive indexes
Author Svein Erling Tysvaer
Hei Asbjørn!

There are some character sets that are case insensitive I think (though
none supporting Scandinavian characters?), but most of us use uppercased
columns populated through triggers. Then you change your select to
something like

UPPER_LASTNAME is the column containing the uppercased copy of LASTNAME

It is just a matter of cooperating with your database rather than try
fighting it.

Velkommen til oss i ib-support (I guess this should be possible to
understand even for those only speaking English),
Svein Erling

At 11:07 04.09.2002 +0200, you wrote:
>Is there a posibility to make indexes case insensitive in firebird, or will
>it be in the nest version.
>I over and over again need to make queries like this in large name datebases
>in fields like LastName, FirstName, Address and so further.
>If I make a Query like this: SELECT ... WHERE UPPER(LASTNAME) LIKE 'JOHN%'
>my Index will be of no use and my Query will be to slow.