Re: Case Settings in Oracle
From: Craig Beevers <cbeevers_at_easynet.co.uk>
Date: Sun, 29 Aug 1999 21:28:29 +0100
Message-ID: <7qc5ec$1p0o$1_at_quince.news.easynet.net>
Date: Sun, 29 Aug 1999 21:28:29 +0100
Message-ID: <7qc5ec$1p0o$1_at_quince.news.easynet.net>
I forgot to mention that the Oracle resides on a SUN box (Solaris 2.6).
When loaded on an NT Oracle install, the Case is not a problem.
-- Best Regards Craig Beevers Craig Beevers <cbeevers_at_easynet.co.uk> wrote in message news:7qbn2q$17s7$1_at_quince.news.easynet.net...Received on Sun Aug 29 1999 - 22:28:29 CEST
>
> Hi,
>
> Is there a way that you can change the whole of an Oracle instance (or
> specific tables) to ignore case when searching
> e.g Select * from x
> where col = " abc"
>
> col
> ------
> ABC
> abc
> ABc
>
> On MS SQL Server 6.5 , you had to reinstall and change the Sort Order.
>
> Is there an equivalent in Oracle 7.3 or 8.0.5. ?
>
> I am aware of the Upper () and Lower (), I am looking for something more
> global.
>
> --
> Best Regards
>
> Craig Beevers
> beevers_at_maincontrol.co.uk
>
>
>
>