Case Sensitive Tables

From: Craig Beevers <>
Date: Sat, 28 Aug 1999 18:45:06 +0100
Message-ID: <7q97g0$1ghe$>


[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"



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 Received on Sat Aug 28 1999 - 19:45:06 CEST

Original text of this message