Re: Export / Import and CharacterSets

From: Piotr Kolodziej <pkol_at_otago.gda.pl>
Date: Thu, 24 Sep 1998 14:11:34 +0200
Message-ID: <6udcse$fk6$1@sunrise.pg.gda.pl>

Rolf Hauck wrote in message <360A316D.D51F99F9_at_datenrevision.de>...
>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:

Generally, you may specify charset parameter while executing imp. This charset says in which charset your export was performed. $ imp user/passwd file=foo log=foo charset=<charset> <other_params>

So according to your description try using: imp user/passwd file=foo log=foo charset=us7ascii <other_params>

BTW, is it really possible keeping German characters in us7ascii ???

HTH,
Piotr Kolodziej
pkol_at_otago.gda.pl Received on Thu Sep 24 1998 - 07:11:34 CDT