Subject Re: [IBO] Case insensitive index
Author Claudio Valderrama C.
""Bob Jones"" <bjones@...> wrote in message
> How do I create an index that is not case sensitive? Is there a property
> that I set to ignore case on the index, or does Interbase support
> indexes?

You will have to rely on
for installable, case-insensitive collations if you want the solution in the
engine and not in the client application.

Otherwise, IBO has you covered with a couple of settings and some trivial
triggers. If you need correct uppercasing in non-ASCII cases, use the
charset that suits your needs.

Claudio Valderrama C. - -
Independent developer
Owner of the Interbase® WebRing