From: "Oscar Arranz" <oscar.arranz@consors.es>
Newsgroups: comp.databases.oracle.server
Subject: Character set questions
Date: Wed, 10 Oct 2001 17:55:49 +0200
Organization: Iddeo - Retevisión
Lines: 27
Message-ID: <9q1r2r$5qs4320@news1s.iddeo2.es>
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!feedme.news.mediaways.net!area.cu.mi.it!kirk.uli.it!phobos.ibnetwork.net!seanews1.seabone.net!garse!news.iddeo.es!not-for-mail
Xref: easynews comp.databases.oracle.server:120834
X-Received-Date: Wed, 10 Oct 2001 09:13:55 MST (news.easynews.com)

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.