Hi,

> Actually by default Interbase is case INSENSITIVE. It's only if you use
> DIALECT 3 in conjunction with quoted-identifiers, that references will
> become case sensitive.
>
> In the case of:
>
> create table his(...);
> create table HIS(...);
> CREATE TABLE HIS(...);
>
> The resulting table can be referenced as:
>
> select * from his
> select * from His
> select * from HIs
> select * from HIS
>
>
> However, if you:
>
> create table "his"(...);
>
> then you can ONLY reference the table as:
>
> select * from "his"
>
> Bottom line: Unless you are looking for trouble -- NEVER use
> quoted-identifiers

<advert>

There are some tools that do this for you. InterBase Workbench, for example,
has an option to 'always use uppercase identifiers'. If you turn it on, you
will only be able to use uppercase identifiers from the editors. This was
one unique feature :)

If you don't have it turned it, will check your identifiers and will only
use quotes if you supply a mixed case identifier or spaces (and other
special characters). If you don't, it will automatically NOT use quotes.
Seems to work quite well. And fixes a lot or problems with the mixed case
identifiers stuff..
</advert>


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

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."