Link to home
Create AccountLog in
Avatar of BrianG
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
ASKER CERTIFIED SOLUTION
Avatar of RCorfman
RCorfman

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer