NLS_COMP and NLS_SORT Initialization Paramaters
Posted on 2006-03-28
I have tried setting the initialization parameters in the SPFile for NLS_COMP=ansi and NLS_SORT=binary_ci. I apply and recycle the server and the parameters are set. However, when I perform a query from SQLPLUS, the database is still case sensitive. If I do SHOW PARAMETER NLS_COMP, the proper values are set. I can run ALTER SESSIONS and set the parameters to get the query to be case insensitive, but that is not ideal.
I am running Oracle 10gR2.