case-insensitive NLS_SORT
- From: Roger Xu <wellmetus@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 19 Aug 2009 09:35:12 -0500
Hi Experts,
We are trying to make our 10g database (Linux) case-insensitive by setting
the following two parameters.
SQL> show parameter NLS_COMP
NAME TYPE VALUE
------------------------------------ ----------- ----------
nls_comp
string ANSI
SQL> show parameter NLS_SORT
NAME TYPE VALUE
------------------------------------ ----------- ------------
nls_sort string BINARY_CI
However, it does not work if we connect to the DB from a client(Windows).
SQL> select sys_context('USERENV','NLS_SORT') from dual;
SYS_CONTEXT('USERENV','NLS_SORT')
--------------------------------------------------------------------------------
BINARY
SQL>
What to do so it works for all clients without doing "Alter Session ...."?
Thanks,
Roger Xu
P.S. Someone asked the same question below but I had a hard time to find out
the solution.
http://www.orafaq.com/forum/t/74537/0/
Other related posts:
