Peter Ondruška wrote:
Not that I know, this is by SQL standard.
On Wed, Mar 24, 2010 at 10:43 PM, Pavel Bortnovskiy
<pbortnovs...@jefferies.com <mailto:pbortnovs...@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