BrianG
asked on
NLS_COMP and NLS_SORT Initialization Paramaters
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.
Thanks,
Brian
I am running Oracle 10gR2.
Thanks,
Brian
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.