Subject | RE: [firebird-support] Reserved words in Firebird migration ! |
---|---|
Author | Leyne, Sean |
Post date | 2004-11-17T19:03:18Z |
Goutam,
become case sensitive and must always thereafter be referred to as
"VALUE" and not "Value" or "value"...
Sean
> > We are migrating mysql to firebird and writing ms-sql server toin
> > firebird scripts, is there any way to keep using the reserved words
> > Firebird.without
> > 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
> > asking the developers to change their code.<snip Martijn's blatant product plug!>
> As for brackets, in Firebird, use double quotes:You also need to know that by using the double quotes, the column name
> "VALUE"
become case sensitive and must always thereafter be referred to as
"VALUE" and not "Value" or "value"...
Sean