Subject Re: [firebird-support] Reserved words in Firebird migration !
Author Martijn Tonies
Hello,

> We are migrating mysql to firebird and writing ms-sql server to
> firebird scripts, is there any way to keep using the reserved words in
> Firebird.
> Like in ms-sql server we could use square brackets [] , eg. [value]
> I can use [value] as a column name in mysql but cannot in firbird.
> Well I do realize the database structure does not follow ANSI
> standards., however it would help me if I have a way around it without
> asking the developers to change their code.

Are you writing scripts? You poor guy... Better download
a trial copy of Database Workbench and check the
Schema Migrator tool :-) ... www.upscene.com

As for brackets, in Firebird, use double quotes:
"VALUE"

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com