Re: NLS_SORT

From: Mark Malakanov <markmal_at_sprint.ca>
Date: Sat, 19 Jun 1999 21:00:00 -0300
Message-ID: <x%Wa3.157431$r_1.32791332@newscontent-02.sprint.ca>

Sorting is parameter of client's session.

If you need change sorting rules (by the way to Spanish) you must set NLS_SORT variable on the client side.
In Win95/NT use Registry Editor (regedit) And change LOCAL_MACHINE/Software/ORACLE/NLS_LANG

In Unix you have to create environment variable NLS_LANG for Unix user. You can do it in Windows/DOS also.

Mark

José Ortuño <gpaloma_at_cesser.com> wrote in message news:7kfp17$gdv$1_at_talia.mad.ttd.net...
> Hi :
>
> I have a problem with ORACLE for NT 8.0.5.0.
>
> Default value for parameter NLS_SORT is BINARY .
>
> In a table run EXPLAIN and result SORT.
>
> With SQL+ runing ALTER SESSION SET NLS_SORT = BINARY
>
> run EXPLAIN and acces by INDEX.
>
> In file INITORACL.ORA
>
> NLS_SORT = BINARY
>
> SHUTDOWN and RESTART.
>
> With INSTANSCE MANAGER ===> NLS_SORT = BINARY but is necesary ALTER
SESSION
> or SORT.
>
> WHY?
>
> Sorry, I do not speak english.
>
> Regards.
>
>
Received on Sat Jun 19 1999 - 19:00:00 CDT