Re: Character set questions

As long as the characterset is the same there should be no problem. You should of course take provisions in your .profile, and you might consider amending oraenv to this effect.

Hth,

Sybrand Bakker
Senior Oracle DBA

"Oscar Arranz" <oscar.arranz_at_consors.es> wrote in message news:9q22nf$5qp8l25_at_news1s.iddeo2.es...
> 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_at_sybrandb.demon.nl> escribió en el mensaje de
> noticias ts91sufgf4g7aa_at_news.demon.nl...
> >
> > "Oscar Arranz" <oscar.arranz_at_consors.es> wrote in message
> > news:9q1r2r$5qs4320_at_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
> >
> >
> >
>
>
Received on Wed Oct 10 2001 - 15:50:39 CDT