Case Settings in Oracle

From: Craig Beevers <>
Date: Sun, 29 Aug 1999 17:23:20 +0100
Message-ID: <7qbn2q$17s7$>


[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 Sun Aug 29 1999 - 18:23:20 CEST

Original text of this message