Re: Case Sensitive Tables
From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: Tue, 31 Aug 1999 14:36:20 GMT
Message-ID: <37CBE864.240CBF5_at_edcmail.cr.usgs.gov>
Date: Tue, 31 Aug 1999 14:36:20 GMT
Message-ID: <37CBE864.240CBF5_at_edcmail.cr.usgs.gov>
As far as I know, there is no way of performing this globally in Oracle. You have to use the Lower or Upper functions.
HTH,
Brian
Craig Beevers wrote:
>
> 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
Received on Tue Aug 31 1999 - 16:36:20 CEST