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 -- //www.freelists.org/webpage/oracle-l