Case Sensitive Tables
From: Craig Beevers <cbeevers_at_easynet.co.uk>
Date: Sat, 28 Aug 1999 18:45:06 +0100
Message-ID: <7q97g0$1ghe$1_at_quince.news.easynet.net>
Hi,
ABC
abc
ABc
Date: Sat, 28 Aug 1999 18:45:06 +0100
Message-ID: <7q97g0$1ghe$1_at_quince.news.easynet.net>
Hi,
[Quoted] [Quoted] 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 Sat Aug 28 1999 - 19:45:06 CEST