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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Character Set Confusion

Re: Character Set Confusion

From: Jim Gregory <JG200024_at_NCR.com>
Date: Thu, 21 Dec 2000 09:46:20 -0500
Message-ID: <3a4217c0$1@rpc1284.daytonoh.ncr.com>

Check to see what your NLS_LANG environment variable to set to. It will over-ride the database setting for exports/imports

--
Jim Gregory
Principal Consultant for Keane, Inc.
Currently assigned to NCR
"Opinions are my own and do not reflect
  those of Keane or my clients"
Feldman Roger <qrarofe_at_era.ericsson.se> wrote in message
news:3A42074B.A05DF1CE_at_era.ericsson.se...

> Oracle People:
>
> I'm writing from Sweden where we have to think about character sets
> often. I'm using a product(RATIONAL) that recommends:
>
> WE8ISO8859P1
>
> When I query the server as to it's Character Set:
>
> SQL> SELECT Name,Value$ FROM sys.props$ WHERE Name='NLS_CHARACTERSET';
>
> NLS_CHARACTERSET
> WE8ISO8859P1
>
> I recieve confirmation that the database is indeed WE8ISO8859P1.
>
> Why then does export, export in USA7ASCII :
> log:
> PL/SQL Release 2.3.4.0.0 - Production
> Export done in US7ASCII character set
>
> The export documention promises that export exports in the character set
> of the export database.
>
> THANX,
> roger_feldman_at_hotmail.com
>
>
>
>
Received on Thu Dec 21 2000 - 08:46:20 CST

Original text of this message

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