db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendle...@amberpoint.com>
Subject Re: quotes problem in query syntax
Date Fri, 16 Nov 2007 15:29:08 GMT
> create table mt ( mf varchar(5) )
> select x."mf" from mt x

If you enclose identifiers (table/column names, etc.) in
double quotes, then the case must match exactly.

So this would work:

   create table mt ( mf varchar(5) )
   select x."MF" from mt x

or this:

   create table mt ( "mf" varchar(5) )
   select x."mf" from mt x

If you do not enclose the identifier in double quotes,
Derby converts it internally to upper case.

thanks,

bryan




Mime
View raw message