ben_ata wrote:

> --- In Firebird-Java@yahoogroups.com, "bullitenergy" <s.hahn@o...>
> wrote:
>
>>However i thought that using "quoted"
>>identifiers was in the SQL standard and [bracketed] identifiers are
>>the MS-SQL and Access extension.
>
>
> AFAIK quoted identifiers should be used to indicate case-sensitive
> usage of column identifiers (e.g. "MyTable" is a different table the
> "MYTABLE" or event then MYTABLE) or if the table name contains
> characters that aren't allowed in table names, or if the table name is
> a reserved word (e.g. in Oracle you cannot create a table USER but you
> can create a table "USER").
>>From my limited knowledge of the ANSI standard, I think this is how
> the usage of quotes is specified there.

at least from the isql you can create table columns with keyword names
like "password", "time"

I think it should work in jaybird if database is created with dialect 3

ps: this is from memory (have to read the docs) and will test it today
if works with one tomcat application that have quoted columns names