| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.server -> Re: character set conversions on export
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...Received on Thu Oct 03 2002 - 19:14:24 CDT
> 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
>
>
>
![]() |
![]() |