EXP/IMP charset conversion, Please help me ...

From: Patrick Mau <mau_at_tony.dorf.wh.uni-dortmund.de>
Date: Wed, 28 Nov 2001 17:46:38 +0000 (UTC)
Message-ID: <slrna0a8nu.ij2.mau@tony.local.net>

I have two databases.
The first one was created with

create database test1

        character set "WE8ISO8859P1"
        national character set "UTF8"

The second one was created using

create database test1

character set UTF8
national character set WE8ISO8859P1

I exported the first one. No I try to import the data into the second database. IMP says:

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

I have two qwuestions.

1)
I think the second setting is "more correct", because the database stores the data in UTF8 and uses the national character set WE8ISO8859P1.

Am I wrong about that ?

2)
How do I use IMP so that no conversion occurs ?

Please help me ;o) I need to import a large dataset ASAP and I don't want to re-create the database.

I would be very pleased if you could Cc me on the reply.

Thanks a lot (really ...)
Patrick Mau Received on Wed Nov 28 2001 - 11:46:38 CST