db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Peter Ondruška <peter.ondru...@gmail.com>
Subject Re: Case Sensitivity
Date Wed, 24 Mar 2010 21:33:44 GMT
select
                    Id as "id",
                    Code as "code",
                    TypeStr as "typeStr"
                  from MyTable

On Wed, Mar 24, 2010 at 10:30 PM, Pavel Bortnovskiy
<PBortnovskiy@jefferies.com> wrote:
>
> Hello, all:
>
> when executing a statement, such as:
>
>                         select
>                     Id as id,
>                     Code as code,
>                     TypeStr as typeStr
>                   from MyTable
>
> against a Derby in-memory table, the ResultSetMetaData present column names
> all in upper case and the original case is not preserved.
>
> Is there a setting which would allow to preserve the case specified in the
> SQL statement, i.e. with the statement above, the first column would be
> "id", second - "code", third - "typeStr", etc...
>
> Thank you,
>
> Pavel.
>
>
>
> 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
> addressee of this email you may not copy, forward, disclose or otherwise use
> it or any part of it in any form whatsoever. This email may be produced at
> the request of regulators or in connection with civil litigation. Jefferies
> accepts no liability for any errors or omissions arising as a result of
> transmission. Use by other than intended recipients is prohibited.  In the
> United Kingdom, Jefferies operates as Jefferies International Limited;
> registered in England: no. 1978621; registered office: Vintners Place, 68
> Upper Thames Street, London EC4V 3BJ.  Jefferies International Limited is
> authorised and regulated by the Financial Services Authority.

Mime
View raw message