|Subject||Re: [firebird-support] Handling keywords as column names|
On Wed, Sep 16, 2009 at 5:55 PM, Alec Swan <alecswan@...> wrote:
> We are porting our legacy database to Firebird. One of the problems we ran
> into is the way Firebird handling queries which select column which names
> are Firebird keywords. For example, executing the first query throws
> "Invalid token." error while the second query works just fine:
> 1. select SIZE from physical_copy
> 2. select "SIZE" from physical_copy
> Escaping all column names and tables requires a lot of changes to the legacy
> code. Is there a way to configure Firebird to gracefully handle these
> situations, e.g. by automatically escaping column name?
Unfortunately, there isn't. You really have to quote your column names.