Subject Re: [Firebird-Java] Re: problem: PreparedStatement with "? IS NULL"
Author marius popa
ben_ata wrote:
> --- In, "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