[SQLObject] Re: Re: Know bugs in Firebird

[Ian S. <ia...@et...>]

"Ian Bicking" <ia...@co...> wrote in message
news:A61...@co......
> It's probably easier if we just start quoting all the columns.  That's
> pretty easy with automatic SQL generation anyway.  Postgres uses
> "column", MySQL `column`, what does Firebird use?  (SQLite?)

Firebird/Interbase quoting example :

CREATE TABLE "my test" (
   id INT NOT NULL,
   username VARCHAR(20) NOT NULL,
   "my other test" VARCHAR(2)
   )

What Luke says about quoting and case-sensitivity is the same for Firebird
too. For the above table this is valid :

SELECT * FROM "my test"

this is not :

SELECT * FROM "MY TEST"

neither is this :

SELECT "my OTHER test" FROM "my test"

Overall quoting seems a good let-out of our reserved word problems but at a
cost....

- Ian S.