Subject Re: [firebird-support] Re: Keyword as column name
Author Martijn Tonies
> > select test."min" from test
> >
> > But personally I would go with a different name anyway.
>
> Thanks for your answer... Yes, I would prefer other column names,
> too, but it's because of migration...
>
> Now, I have another question... As Firebird generally seems to be
> case insensitive regarding column names, the quoted column seems to
> be so...
>
> select x from y = select X from y = select "x" from y != select "X"
> from y
>
> Is there a way to make firebird's treatment of quoted column names
> case insensitive, too?

No, using quotes (when creating) make them case sensitive unless
you have them uppercased when creating the table.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com