--- In firebird-support@yahoogroups.com, "heineferreira" <heineferreira@...> wrote:

>
> I read from a google search that in order to make Firebird case
> insensitive one must use the unicode coallation.
> I am however confused. I come from a SQL Server background and
> know that the default installation of SQL Server is case insensitive.
> A friend of mine says he always uses character set "none" with Firebird.
> H.F.

Hi,

In case it is of interest, one approach is to create COMPUTED BY rather than standard indexes on important columns:

e.g.
CREATE UNIQUE INDEX I_COMPANY_NAME ON COMPANY COMPUTED BY (UPPER(NAME));

Then just use UPPER() within your SQL and you get speed + case-insensitivity.

HTH,
Tom