Re: Characters losts during Import (8.1.6) -> (9.2.0.6)

On Wed, 05 Jul 2006 14:46:51 +0200, Cris Carampa <cris119_at_operamail.com> wrote:

>I know this is the correct method, but going that way the OP would lose
>all the French characters, because, according to my experience, imp on
>the "target" database (which is WE8ISO8859P1) will truncate all the
>8-bit characters of a US7ASCII export file during import. That's why I
>suggested SQL*Loader.

If that would have been true, your advice is NOT going to work, as SQL*Loader uses *exactly* the same mechanism. The OPs problem probably is he is storing 8 bit characters in a 7 bit database. That has nothing to do with exp/imp not being capable of converting a characterset.
You are spreading fairy tales.

--
Sybrand Bakker, Senior Oracle DBA