case-insensitive NLS_SORT

From: Roger Xu <wellmetus_at_gmail.com>
Date: Wed, 19 Aug 2009 09:35:12 -0500
Message-ID: <eb64345d0908190735j7b5185dcxd90dcee39cf0c4aa_at_mail.gmail.com>

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/

--

http://www.freelists.org/webpage/oracle-l Received on Wed Aug 19 2009 - 09:35:12 CDT