Export / Import and CharacterSets

From: Rolf Hauck <Rolf.Hauck_at_datenrevision.de>
Date: Thu, 24 Sep 1998 13:47:57 +0200
Message-ID: <360A316D.D51F99F9@datenrevision.de>

Hi,
I'm trying to transport character data from our develepment database to production database, and I'm losing all my German characters. The development system is set up with NLS_LANG=AMERICAN_AMERICA.US7ASCII (Oracle 7.3.2.3). The production system uses AMERICAN_AMERICA.WE8ISO8859P1 (Oracle 7.3.4). I can't make exp/imp behave like it's documented:

From Ora 7 Server Utilities Guide:
The export file identifies the character encoding scheme used for the character data in the file. If that character set is any single-byte character set (for example, EBCDIC or USASCII7), and if the character set used by the target database is also a single-byte character set, then the data is automatically converted to the character encoding scheme specified for the user session during import, as specified by the NLS_LANG parameter. After the data has been converted to the session character set, it is then converted to the database character set.

What am I missing?

TIA Rolf Received on Thu Sep 24 1998 - 06:47:57 CDT