Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 14028 invoked from network); 24 Mar 2010 22:06:58 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 24 Mar 2010 22:06:58 -0000 Received: (qmail 17859 invoked by uid 500); 24 Mar 2010 22:06:57 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 17833 invoked by uid 500); 24 Mar 2010 22:06:57 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 17826 invoked by uid 99); 24 Mar 2010 22:06:57 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 24 Mar 2010 22:06:57 +0000 X-ASF-Spam-Status: No, hits=1.0 required=10.0 tests=AWL,HTML_MESSAGE,RCVD_IN_DNSWL_MED,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: local policy) Received: from [216.82.241.99] (HELO mail51.messagelabs.com) (216.82.241.99) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 24 Mar 2010 22:06:51 +0000 X-VirusChecked: Checked X-Env-Sender: PBortnovskiy@Jefferies.com X-Msg-Ref: server-8.tower-51.messagelabs.com!1269468390!30027845!1 X-StarScan-Version: 6.2.4; banners=-,-,- X-Originating-IP: [169.196.176.23] Received: (qmail 24319 invoked from network); 24 Mar 2010 22:06:30 -0000 Received: from jefsmtp11.jefferies.com (HELO JEFSMTP11.jefferies.com) (169.196.176.23) by server-8.tower-51.messagelabs.com with RC4-SHA encrypted SMTP; 24 Mar 2010 22:06:30 -0000 In-Reply-To: <4BAA8BDC.4090703@optrak.co.uk> To: "Derby Discussion" Subject: Re: Case Sensitivity MIME-Version: 1.0 X-Mailer: Lotus Notes Release 7.0.3 September 26, 2007 From: Pavel Bortnovskiy Message-ID: Date: Wed, 24 Mar 2010 18:06:29 -0400 X-MIMETrack: Serialize by Router on JefSMTP11/JEFCO(Release 7.0.3|September 26, 2007) at 03/24/2010 06:06:30 PM, Serialize complete at 03/24/2010 06:06:30 PM Content-Type: multipart/alternative; boundary="=_alternative 007971A8852576F0_=" This is a multipart message in MIME format. --=_alternative 007971A8852576F0_= Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: quoted-printable Thank you, Mark and Peter, for your immediate help and explanation. Mark Thornton =20 03/24/2010 06:02 PM Please respond to "Derby Discussion" To Derby Discussion cc Subject Re: Case Sensitivity Peter Ondru?ka wrote: > Not that I know, this is by SQL standard. > > On Wed, Mar 24, 2010 at 10:43 PM, Pavel Bortnovskiy=20 > > 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=20 omitted? > Databases like SQLServer that do preserve the case violate the standard=20 by ignoring the case of quoted identifiers. On a standard conforming=20 database, converting unquoted identifiers to upper case is unavoidable. Mark Thornton Jefferies archives and monitors outgoing and incoming e-mail. The contents = of this email, including any attachments, are confidential to the ordinary = user of the email address to which it was addressed. If you are not the add= ressee of this email you may not copy, forward, disclose or otherwise use i= t or any part of it in any form whatsoever. This email may be produced at t= he request of regulators or in connection with civil litigation. Jefferies = accepts no liability for any errors or omissions arising as a result of tra= nsmission. Use by other than intended recipients is prohibited. In the Uni= ted Kingdom, Jefferies operates as Jefferies International Limited; registe= red in England: no. 1978621; registered office: Vintners Place, 68 Upper Th= ames Street, London EC4V 3BJ. Jefferies International Limited is authorise= d and regulated by the Financial Services Authority. --=_alternative 007971A8852576F0_= Content-Type: text/html; charset="ISO-8859-1" Content-Transfer-Encoding: quoted-printable
Thank you, Mark and Peter, for your immediate help and explanation.





Mark Thornton <mthornton@optra= k.co.uk>

03/24/2010 06:02 PM
Please respond to
"Derby Discussion" <derby-user@db.apache.org>
<= /table>
To
Derby Discussion <derby-user@db.a= pache.org>
cc
Subject
Re: Case Sensitivity





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&g= t;> 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

Jefferies archives and monitors outgoing and incoming e-mail. The = contents of this email, including any attachments, are confidential to the = ordinary user of the email address to which it was addressed. If you are no= t the addressee of this email you may not copy, forward, disclose or otherw= ise use it or any part of it in any form whatsoever. This email may be prod= uced at the request of regulators or in connection with civil litigation. J= efferies accepts no liability for any errors or omissions arising as a resu= lt of transmission. Use by other than intended recipients is prohibited. &n= bsp;In the United Kingdom, Jefferies operates as Jefferies International Li= mited; registered in England: no. 1978621; registered office: Vintners Plac= e, 68 Upper Thames Street, London EC4V 3BJ.  Jefferies International L= imited is authorised and regulated by the Financial Services Authority. --=_alternative 007971A8852576F0_=--