From: "Oscar Arranz" <oscar.arranz@consors.es>
Newsgroups: comp.databases.oracle.server
Subject: RE: Character set questions
Date: Wed, 10 Oct 2001 20:06:17 +0200
Organization: Iddeo - Retevisión
Lines: 63
Message-ID: <9q22nf$5qp8l25@news1s.iddeo2.es>
References: <9q1r2r$5qs4320@news1s.iddeo2.es> <ts91sufgf4g7aa@news.demon.nl>
NNTP-Posting-Host: 62.81.255.202
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Path: news.easynews.com!easynews!newshub2.home.com!news.home.com!news.maxwell.syr.edu!feed2.uncensored-news.com!propagator!feed2.newsfeeds.com!newsfeeds.com!news-in-austin.nuthinbutnews.com!zamboni.dsnet.it!phobos.ibnetwork.net!seanews1.seabone.net!garse!news.iddeo.es!not-for-mail
Xref: easynews comp.databases.oracle.server:120849
X-Received-Date: Wed, 10 Oct 2001 11:09:24 MST (news.easynews.com)

Thanks for your quik answer.

Ok, but can I run different instances with different NLS values? In fact I
have a cluster with some instances running with NLS set to SPANISH and now I
need to run another with NLS set to AMERICAN. Is this possible?

Oscar.
Sybrand Bakker <postbus@sybrandb.demon.nl> escribió en el mensaje de
noticias ts91sufgf4g7aa@news.demon.nl...
>
> "Oscar Arranz" <oscar.arranz@consors.es> wrote in message
> news:9q1r2r$5qs4320@news1s.iddeo2.es...
> > Hi everybody.
> >
> >     I'm a newbie in Oracle administration, and I have some questions
> > regarding character sets.
> >
> >     I have two Oracle servers, one is for development environment
(oradev)
> > and the other is for production (oraprod). My NLS_LANG variable in
oradev
> is
> > AMERICAN_AMERICA.WE8ISO8859P1 and in oraprod it's
> SPANISH_SPAIN.WE8ISO8859P1
> > .
> >
> >     When I export data from one to another server I see some different
> > issues:
> >
> >     - If I use sql*plus in oraprod with SPANISH configuration I get
dates
> > like 20/09/01
> >     - If I change NLS_LANG to AMERICAN in oraprod and I use sql*plus I
get
> > dates like 20-Sep-01
> >     - On both cases I get errors from an application running on Weblogic
> and
> > using a pool. This application needs dates on AMERICAN format, but I
don't
> > know what's happening. Do I need to set this variable to AMERICAN for
user
> > in weblogic production machine?
> >
> > Thanks in advance.
> >
> > Oscar.
> >
> >
>
> Several env vars derive from NLS_LANG
> NLS_DATE_FORMAT is one of them.
> You only have to change/set NLS_DATE_FORMAT to the format you want,
without
> changing NLS_LANG, so you override the default NLS_DATE_FORMAT
>
> Hth,
>
> Sybrand Bakker, Senior Oracle DBA
>
>
>