Re: Can I make oracle case sensitive

From: <shmurphy_at_my-deja.com>
Date: Fri, 10 Sep 1999 16:57:48 GMT
Message-ID: <7rbda6$jnq$1@nnrp1.deja.com>

In article <h79C3.1144$Ctq.25559171_at_tomcat.sk.sympatico.ca>, "Brant Remenda" <Brant.Remenda_at_PelicanForge.com> wrote:
> Is it possible to make Oracle case sensitive. I am using Oracle 8 and
would
> like to make it case sensitive so that an SQL statement such as:
> Select * from Customers
> would not work if the Customers table is spelled CUSTOMERS
>
> I would also like to make columns case sensitive.
>
> Thanks in advance
> Brant
>
> Brant, it's usually better to ride a wave than swim against it. You're
also much better off handling the data within your app. If, at the beginning of a modual (before any other code) you place "Option Compare Text" (just as you might "Option Explicit) then you'll be telling your VB SQL statement that you don't want to ignore the case. The default in VB is Option Binary which automatically compares by case.

Just a another tip, try not to use NOT NULL in Oracle unless your project demands it. It better to test for conditions within your app than waiting for Oracle to give you a run-time error.

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Sep 10 1999 - 11:57:48 CDT