Subject | Re: [firebird-support] Re: Keyword as column name |
---|---|
Author | Martijn Tonies |
Post date | 2004-04-14T09:43:16Z |
> > select test."min" from testNo, using quotes (when creating) make them case sensitive unless
> >
> > 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?
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