Re: National settings

From: Anurag Varma <avarmadba.skipthis_at_yahoo.com>
Date: Fri, 22 Aug 2003 22:59:23 GMT
Message-ID: <ffx1b.1120$Jq1.565@nwrddc03.gnilink.net>

"szalas" <gszalach_at_hotmail.com> wrote in message news:bi5kjv$jt8$1_at_julia.coi.pw.edu.pl...
> >
> > The settings are derived from registry variables located under the
> > Oracle_home key your product is using.
> > That said, you should *never ever* rely on client's NLS settings
> >
> >
> > Sybrand Bakker, Senior Oracle DBA
> >
>
> But application, toad and database were on the same computer so why did I
> notice any differences ??
>
> szalas
>
>

Szalas,

It depends on what you application was. The nls settings are not always determined by
the local NLS settings. The thin driver gets some of these NLS settings from the server.

For a start you might be interested in browsing through this FAQ: http://technet.oracle.com/products/oracle8i/htdocs/faq_combined.htm

Pretty good for a start. After that, look into Oracle globalization support document for more details.

hth

Anurag Received on Fri Aug 22 2003 - 17:59:23 CDT