Re: case-insensitive NLS_SORT

From: Adam Musch <ahmusch_at_gmail.com>
Date: Wed, 19 Aug 2009 09:39:55 -0500
Message-ID: <516d05a0908190739v551081fdta6bf0159a44839ce_at_mail.gmail.com>

A login trigger using ALTER SESSION calls is about the only workable solution. The client installation's NLS values override any defaults set at the instance or database level.

On Wed, Aug 19, 2009 at 9:35 AM, Roger Xu<wellmetus_at_gmail.com> wrote:
> 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/
>

-- 
Adam Musch
ahmusch_at_gmail.com
--
http://www.freelists.org/webpage/oracle-l

Received on Wed Aug 19 2009 - 09:39:55 CDT