Hi,

Everything (accept string matches in WHERE clauses) is case insensitive
by default. That is, if you create them without double quotes, they're
case insensitive.

<advert>
InterBase Workbench uses uppercase/non-quoted identifiers by default. It
even warns you when using IB/FB keywords - they are allowed with quoted
identifiers, but the application will warn you - or SQL92/99 keywords.
Even if you select to use quoted identifiers, InterBase Workbench will
warn you that you're about to create an object that you have to use
quotes for.
</advert>

As for InterClient, I believe you have to have at least IC 2.0 to
support quoted identifiers.

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com


I have been using Firebird for sometime now, and somehow come to the
conviction that table and column names where case insensitive. They are
not, it seems. Did I miss out on some important documentation notes?
Shouldn't admin tools warn you that they change the case for you? Im
using interclient to connect to the databases I've created. How can I
change this "to uppercase" behavior of interclient?