SQL specifications require that unquoted identifiers be cast to upper
case.

Quoted identifiers are not cast.

create table "tblItem" (
"ItemID" integer,
"ItemName" varchar(100)
)

This is a legacy from the days when lowercase was an option that was debated in the industry. The debate is over, but there are places we still feel its impact.

On Mon, 2005-05-09 at 03:46 +0000, MichaelS wrote:
> I'm quite unused to firebird's apparent use of uppercase letters for
> field names etc. Is this an acutal requirement, or is it optional?
> What about firebird 2? If it's a requirement, why...don't like it any
> more than I would if I was forced to type this msg in uppercase.
> Varying case helps so much with names:
>
> tblItem
> tblItem.ItemID
> tblItem.ItemName
>
> Much nicer than
>
> TBL_ITEM
> TBL_ITEM.ITEMID
> TBL_ITEM.ITEMNAME
>
> Feels like using dBase...
>
> I have the firebird book (as an ebook, what a mistake!) but I can't
> find any reference to this topic there at all.
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>