Subject Re: [firebird-support] Upper case behaviour
Author Ann W. Harrison
Geoff Worboys wrote:

>
> Firebird and SQL are actually defined to have case-sensitive
> names,

Actually, no they're not. They're defined to have identifiers
which can be regular or delimited.

Regular identifiers contain characters from a limited subset of
Unicode, which excludes white space characters. Comparisons
between regular identifiers are case-insensitive and are performed
as if each lower-case character were replaced by its upper-case
equivalent(s).

Delimited identifiers are surrounded by double quotes, may
contain any character though some require escapes, may be
SQL keywords, and are case sensitive.


Cheers,


Ann