Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Are Columns Case insensitive in Oracle 8.1.5?

Re: Are Columns Case insensitive in Oracle 8.1.5?

From: DriftWood <driftwood_at_thebeach.fla.org>
Date: Fri, 21 Jan 2000 17:10:04 GMT
Message-ID: <388b92a6.943150989@newshost.us.oracle.com>


On Fri, 21 Jan 2000 12:12:22 +0100, "Dirk Poppke" <poppke_at_iug.cs.uni-dortmund.de> wrote:

>Hello!
>
>I have problems with the casesensitiveness of Oracle. I would like to
>create Columns wich are case sensitive. I send them with JDBC 2.0
>to Oracle and it seems that Oracle makes them all to UpperCase!?
>
>Has someone a clue?
>
>Thanks,
>Dirk
>

Identifiers such as that are considered case insensitive unless enclosed in double quotes. Even then take care, not all Oracle tools will expect tables or columns to be case sensitive so some of them may not work correctly with tables structured so. Received on Fri Jan 21 2000 - 11:10:04 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US