case-insensitive NLS_SORT

From: Roger Xu <>
Date: Wed, 19 Aug 2009 09:35:12 -0500
Message-ID: <>

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')

What to do so it works for all clients without doing "Alter Session ...."?


Roger Xu

P.S. Someone asked the same question below but I had a hard time to find out the solution.

-- Received on Wed Aug 19 2009 - 09:35:12 CDT

Original text of this message