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.

Regards,

Fidel.