db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mark Thornton <mthorn...@optrak.co.uk>
Subject Re: Case Sensitivity
Date Wed, 24 Mar 2010 22:02:04 GMT
Peter Ondruška wrote:
> Not that I know, this is by SQL standard.
> On Wed, Mar 24, 2010 at 10:43 PM, Pavel Bortnovskiy 
> <PBortnovskiy@jefferies.com <mailto:PBortnovskiy@jefferies.com>> wrote:
>     Thank you, Peter, for your prompt response. Is enclosing them in
>     quotes the only way to do so? Is there any setting which can be
>     applied to Derby (or a -Define), so that the quotes could be omitted?
Databases like SQLServer that do preserve the case violate the standard 
by ignoring the case of quoted identifiers. On a standard conforming 
database, converting unquoted identifiers to upper case is unavoidable.

Mark Thornton

View raw message