On Tuesday, 10. July 2001 11:45, you wrote:
> > When a new table or field is created without quotes, it is assumed to be
> > case-insensitive. Herefore I have some questions:
> >
> > - Is it SQL-92-conform to handle >"test"< like >test< without quotes, or
> > shouldn't it be >test< forced to lowercase?
>
> I do not understand this question. If you want case sensitivity, you need
> to quote your identifiers. Unquoted identifiers are case insensitive.
> I do not think the standard states what should happen when you start mixing
> quoted and unquoted identifiers for the same object.
OK, lets assume I want the field test explicitly in lowercase (and ONLY in
lowercase). I can see no way to make this with the current implementation.
By the way in Oracle, we have the same problem, but everything is in
uppercase.
Regards & thanks
Klaus
--
Visit WWWdb at
http://wwwdb.org