Re: Are Columns Case insensitive in Oracle 8.1.5?

From: Malcolm Dew-Jones <yf110_at_vtn1.victoria.tc.ca>
Date: 21 Jan 2000 09:38:37 -0800
Message-ID: <3888999d@news.victoria.tc.ca>

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!?

Try use the double quote character around the column names e.g. "MyColumn". (I've read this but never used it).

I've used ODBC to accidently create lowercase table and/or column names, and it caused all sorts of other problems when trying to use the data from within Oracle, so I would be leery of using this much.

: Has someone a clue?

: Thanks,
: Dirk

-- Received on Fri Jan 21 2000 - 11:38:37 CST