RE: Characterset / conversion problem

From: Marco Gralike <Marco.Gralike_at_AMIS.nl>
Date: Thu, 15 Sep 2005 10:05:30 +0200
Message-ID: <3FA1E6332C73EB4391F729E4EDB7CED910E062@amisnt30.AMIS.local>

During every step off export/import/etc you have to be aware of your NLS settings. For instance if your NLS setting of your client connection was different from that of your database, you will encounter charaterset conversion during your export.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of BERNHARD Nora Sent: donderdag 15 september 2005 9:27
To: oracle-l_at_freelists.org
Subject: Characterset / conversion problem

Hi all,

I am planning to move a production database from 8.1.7 to 10g, where both the database characterset and the national characterset is specified as WE8MSWIN1252. The data contains several special characters (umlauts). Because for this version it isn't anymore possible to define another national characterset but AL16UTF16 and UTF8, I tried both of these, but nevertheless my data is being converted at import which results in loss of umlauts.

*) Oracle 8.1.7:

PARAMETER                      VALUE
------------------------------ ----------------------------------------
NLS_NUMERIC_CHARACTERS         .,
NLS_CHARACTERSET               WE8MSWIN1252
NLS_NCHAR_CHARACTERSET         WE8MSWIN1252

*) Oracle 10g:

PARAMETER                      VALUE
------------------------------ ----------------------------------------
NLS_NUMERIC_CHARACTERS         .,
NLS_CHARACTERSET               WE8MSWIN1252
NLS_NCHAR_CONV_EXCP            FALSE
NLS_NCHAR_CHARACTERSET         UTF8

*) Import logfile:

Export file created by EXPORT:V08.01.07 via conventional path import done in US7ASCII character set and UTF8 NCHAR character set import server uses WE8MSWIN1252 character set (possible charset conversion) export client uses WE8MSWIN1252 character set (possible charset conversion) export server uses WE8MSWIN1252 NCHAR character set (possible ncharset conversion)

What am I doing wrong here?

Thanks :)

Nora Bernhard
OE Informationstechnologie - Systemadministration Tel: +43 (0)316 8035 - 1349
Fax: +43 (0)316 8035 - 661349
mailto: nora.bernhard_at_stgkk.sozvers.at

Steiermärkische Gebietskrankenkasse
A-8011 Graz, Josef-Pongratz-Platz 1
http://www.stgkk.at

--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l

Received on Thu Sep 15 2005 - 03:10:20 CDT