Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Character Set Confusion
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...Received on Thu Dec 21 2000 - 08:46:20 CST
> 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
>
>
>
>