Interesting, and good. How long has dialect 3 been out? Is it included
in the later 1.x versions? Sounds like it not just there in 2.0.

--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@...> wrote:

>
> Michael,
>
>
> >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:
>
> MiXedCase
> MIXEDCASE
> mixedcase
>
> 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
> http://www.upscene.com
> My thoughts:
> http://blog.upscene.com/martijn/
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com
>