Subject Re: [firebird-support] Does Firebird 2.0 support mixed case in field names?
Author Martijn Tonies

>Just curious, earlier versions didn't as far as I could tell.
>IE does the new Firebird support a field name like EntityID, or does
>it force to ENTITYID?

Firebird doesn't force anything.

Here's the deal:

Firebird SQL comes in two versions, "dialect 1" and "dialect 3" (there
is a "dialect 2", but we won't talk about that now).

Dialect 1 disallows case sensitive names, spaces, special characters,
keywords etc...

If you do: CREATE TABLE MixedCase ... etc...

Firebird will return this as MIXEDCASE, but you can use SELECT
* FROM MixedCASe if you like.

Now, with Dialect 3, Firebird allows you to decide if you want case
sensitive names, keywords in names, special characters etc...

You can force case and all of the above by using double quotes:

TABLE "MixedCase"

can only be used as: "MixedCase"

TABLE mixedCase (without quotes) can be used as:


See the difference? No quotes: no case enforcing, quotes: case enforcing
EXCEPT if you used all uppercase case characters.

Hope this helps.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
My thoughts:
Database development questions? Check the forum!