Setting NLS_COMP and NLS_SORT at the database level

From: <ymongeau_at_chca.ca>
Date: 16 May 2007 08:22:21 -0700
Message-ID: <1179328941.052876.115070@o5g2000hsb.googlegroups.com>

Hi,

I am running Oracle 10g Release 2 (10.2.0.1).

I have set the NLS_COMP parameter to LINGUISTIC and the NLS_SORT parameter to BINARY_AI in the spFile through Oracle Entreprise Manager. I have shut down and restarted the database.

>From Oracle Entreprise Manager (/Administration / All initialization
parameters), I can see that the values for the parameters are the ones mentioned above. However, I cannot perform a case-insensitive and accent-insensitive search.

If I change it at the session level
ALTER SESSION SET NLS_COMP=LINGUISTIC
ALTER SESSION SET NLS_SORT=BINARY_AI
it works fine.

Is there another parameter to set in order to have this at the database level?

Thanks for your help. Received on Wed May 16 2007 - 10:22:21 CDT