Subject Re: [firebird-support] Case-insensitive selects
Author Paul Vinkenoog
Hello Thomas,

> I have just started (or trying to) using the firebird/interbase
> database to store data, and one of my first problems is that all
> selects are case-sensitive. Is there a way to turn this feature off?

No, but you can select or order on UPPER( FieldName ) to achieve case
insensitivity. This decreases performance, so if you do it often on
certain columns, it's better to add an all-uppercase proxy column
(populated through triggers) and use that proxy column to select
and/or order on.

Also bear in mind that CONTAINING is case insensitive. LIKE, STARTING
WITH, etc. are case sensitive.

Hope this helps,
Paul Vinkenoog