This discussion is archived
6 Replies Latest reply: Apr 21, 2011 8:14 AM by Sergiusz Wolicki (Oracle) RSS

Setting NLS_COMP and NLS_SORT for all Sessions

849256 Newbie
Currently Being Moderated
Hi all,

I searched in the Forum/Google/etc,... but unfortunaly I don't found a solution.

For our Application we need an case insenstive search. So if we set the change the Session Parameters to NLS_COMP=LINGUISTIC and NLS_SORT=BINARY_CI it works fine. Now set this two Parmeters in the NLS_INSTANCE_PARAMETERS.
Now when I start SQLPLUS and check the NLS_SESSION_PAREMTERS they NLS_COMP is correct but the NLS_SORT is set to NLS_SORT=GERMAN .

Is there are way to force this Paremters from INSTANCE so that every Client always use the Parameter from NLS_INSTANCE_PARAMETERS?

Due that it's not an own Application we can't use ALTER SESSION SET .... .

regards
Thomas

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points