Re: Case insensitive searches

From: Martin Klier <usn_at_usn-it.de>
Date: Tue, 18 Mar 2014 13:28:12 +0100
Message-ID: <53283BDC.5000000_at_usn-it.de>



Hi Ryan,

we are running more than 50 projects on 11.2.x with NLS_SORT set to BINARY_CI and NLS_COMP to LINGUISTIC.

We do two things:
* both parameters are only set on session level for the app users and NOT for SYSTEM or the dictionary owner.
* all VARCHAR field indexes are changed to function based: NLSSORT(MY_TEXT_FIELD, 'NLS_SORT=BINARY_CI') Because this function is what Oracle wraps around any string search when the mentioned parameters are set.

Hope this helps
Martin Klier

Am 17.03.2014 23:02, schrieb Ryan January:
> to set NLS_SORT to BINARY_CI and NLS_COMP to LINGUISTIC

-- 
Usn's IT Blog for Oracle and Linux
http://www.usn-it.de

performing databases
Your reliability. Our concern.
http://www.performing-databases.com

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Mar 18 2014 - 13:28:12 CET

Original text of this message