Subject Re: [firebird-support] Double quotes in Firebird 2.0 (follow up)
Author Martijn Tonies
Hello Hubert,

>I am just beginning to work on Firebird 2.0 and have also just joined this
>group. Thus I couldn't participate directly to the yesterday thread about
>I am also new to FB 2.0 and FlameRobin as GUI. It seems that there, all
>identifiers must have double quotes (I could not bring it to work without,
>although the DB is dialect 3). I want to migrate from MySQL and test a lot
>of queries (without double quotes). Is there a way (other GUIs or which is
>the best way to do it?) to get rid of them? These double quotes need sounds
>me a bit strange: all DBs that I have seen until now did not need this.

You don't "need" double quotes, if your identifiers aren't reserved words.
If so, or if you want to make them case sensitive, you do need them.

Some examples:

create table table ...
-> fails.

create table "TABLE"
-> works.

create table "CaseTest"

select * from casetest
-> fails.

select * from "CaseTest"
-> works

create table "CASETEST"

select * from casetest
-> works (all uppercase in quotes equals no quotes)

select * from "casetest"
-> fails

select * from "CASETEST"
-> works

Hope this helps.

>By the way, do you know about a migration Tool (data pump) which also
>overtake keys and indices from MySQL?

Yes, Database Workbench -

It works with MySQL, Firebird, InterBase, SQL Server, Oracle and NexusDB,
including migration of metadata.

Database Workbench doesn't use quoted identifiers unless you're using a
then it will warn you (when creating objects), saying you're using a keyword
that the identifier becomes "delimited".

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