Hi,

when we import with a character set different from the database
we have the follwing error (from memory):

import done in ...
server server uses ...
export client uses ...
export server uses
conversion ...

Is it a real pb (data lost) or it is a warning and the conversion is done
so no data lost ?

Thanks for your insights

On Oct 9, 7:14*am, "bob123" <nom... (AT) nowhere (DOT) com> wrote:
The the actual information/error messages and information on the
export and import Oracle versions would be helpful.

The import./export process will automatically convert the data from
the export character set to the import target database character set
if it can. Not all characters translate between all sets and these
usually show up as a question mark.

Without a system in front of me I cannot run a quick test to see how
many of these messages are normal but even so without your actual
messages any response might still be wrong.

HTH -- Mark D Powell --

On Oct 9, 4:14*am, "bob123" <nom... (AT) nowhere (DOT) com> wrote:
It depends. For example, if you have eight bit data in a seven bit
character set - which can happen easily - you would lose the eighth
bit. If you set things up to make Oracle think it is not converting,
you would avoid such a problem.

As Mark almost said, we would need the character sets involved, the
exact versions, the exact error messages, and the NLS settings of
everything involved.

There are several Oracle docs that can help here, including the
Utilities manual and Globalization guides, as well as MOS docs and
some web sites. There is documentation on which character sets are
sub or supersets, and a csscan utility that can help with determining
if a problem would exist.

jg
--
@home.com is bogus.
http://www.signonsandiego.com/news/2...indows-phones/