Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: character set conversions on export

Re: character set conversions on export

From: Alex Ivascu <alex_at_ivascu.comNoSpam>
Date: Fri, 04 Oct 2002 00:14:24 GMT
Message-ID: <A35n9.31547$Pz.22166@rwcrnsc51.ops.asp.att.net>


It does not seem to work the same way as explicitly defining NLS_LANG as an environment variable, such as:
set NLS_LANG=american_america.UTF8
exp uname/pass blah blah blah

See if that works.

--
Alex Ivascu


"Surya" <sdpantab_at_yahoo.com> wrote in message
news:Cn%m9.122466$Yb1.112109_at_sea-read.news.verio.net...

> Hi all,
>
> My database nls settings are defined as below. and the nls_lang seetings
in
> the windows 2000 machine registry is AMERICAN_AMERICA.UTF8. But when I
> export I get the follwoing error as I must be missing something:
>
> Connected to: Oracle8i Release 8.1.7.0.0 - Production
> JServer Release 8.1.7.0.0 - Production
> Export done in WE8ISO8859P1 character set and UTF8 NCHAR character set
> server uses UTF8 character set (possible charset conversion)
>
>
> PARAMETER VALUE
>
> ------------------------------ ----------------------------------------
>
> NLS_LANGUAGE AMERICAN
>
> NLS_TERRITORY AMERICA
>
> NLS_CURRENCY $
>
> NLS_ISO_CURRENCY AMERICA
>
> NLS_NUMERIC_CHARACTERS .,
>
> NLS_CHARACTERSET UTF8
>
> NLS_CALENDAR GREGORIAN
>
> NLS_DATE_FORMAT DD-MON-RR
>
> NLS_DATE_LANGUAGE AMERICAN
>
> NLS_SORT BINARY
>
> NLS_TIME_FORMAT HH.MI.SSXFF AM
>
> NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
>
> NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZH:TZM
>
> NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZH:TZM
>
> NLS_DUAL_CURRENCY $
>
> NLS_COMP BINARY
>
> NLS_NCHAR_CHARACTERSET UTF8
>
> NLS_RDBMS_VERSION 8.1.7.0.0
>
> Any help would be appreciated to spare me from the characther conversions.
>
> TIA,
>
> SP
>
>
>
Received on Thu Oct 03 2002 - 19:14:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US