Re: SQLPrimaryKeys & case (ODBC)

From: Alan Shein <alanshein_at_erols.com>
Date: Mon, 13 Dec 1999 10:16:19 -0500
Message-ID: <8332k3$1n6$1@autumn.news.rcn.net>

ODBC always places " " around table and column names, so when you use ODBC to create tables in Oracle, the names become case sensitive. The best way to avoid the problem is to always use UPPER CASE when naming tables and columns in ODBC. Once names are stored in Oracle in upper case, Oracle doesn't care what case you use after that point.

HTH
Alan Shein

Shige Takeda <smtakeda_at_earthlink.net> wrote in message news:38540260.459805F5_at_earthlink.net...
> Gerard van Dorth wrote:
> >
> > Why do i have to "" (quote) a table name in SQLPrimaryKeys calls to
prevent
> > it from case conversion?
> > Yet Another Buggy Oracle Driver?
>
> I believe this is the spec of Oracle, but not a ODBC's bug.
> Table name is incase-sensitive unless the name is surrounded by
> double quotes.
> --
> Shige Takeda
> smtakeda_at_earthlink.net
Received on Mon Dec 13 1999 - 09:16:19 CST