Re: NLS_LANG

Hi Alan,

Have a good read of the Oracle Reference Manual and National Language Support (Globalization Support in 9i) manuals (http://tahiti.oracle.com) which explains the purpose of all Oracle parameters and how NLS works in general.

Basically, the NLS_ parameters control the default behaviour of language specific attributes such as language, date formats, sorting characteristics, numbering displays, etc. etc. for each *server* session (ie. the process that runs on the backend). All operations performed at the server end use these NLS values (note BTW this can be changed for a specific session via an alter session command).

However each client process (eg. SQL*PLUS session) can have *different* NLS characteristics set via client end NLS environment variables. All operations performed on the client (such as formatting of data) use these NLS values. And of course all clients are different and can use different NLS settings as appropriate.

There's a lot to it all, have a good read.

Regards

Richard

"Alan" <athiery_at_ais-nantes.fr> wrote in message news:3d350e01$0$10507$626a54ce_at_news.free.fr...
> I have in the Oracle 8.1.7 doc
>
>
> As initialization parameters on the server. You can include parameters in
>
> the initialization parameter file to specify a default session NLS
>
> environment. These settings have no effect on the client side; they
control
>
> only the server's behavior. For example:
>
>
> NLS_TERRITORY = "CZECH REPUBLIC"
>
>
> What does mean 'These settings have no effect on the client side'. What is
>
> the effect of these parameters on the instance and the database. On what
> program it impact ???
>
>
> Alan
>
>
>
>
>
>
Received on Wed Jul 17 2002 - 03:57:07 CDT