Import character set issue:

From: Francesco M. <fmarchioni_at_libero.it>
Date: 4 Feb 2005 01:41:35 -0800
Message-ID: <9bf4beba.0502040141.6c88ad6c@posting.google.com>

Hi all,
I have exported on table from one DB to another. I have this issue:

import done in US7ASCII character set and AL16UTF16 NCHAR character set
import server uses WE8ISO8859P1 character set (possible charset conversion)
export server uses US7ASCII NCHAR character set (possible ncharset conversion)

I have found an interesting article which explains how to indentify a character set:
http://www.dbaoncall.net/references/ht_identify_charset.html

but I haven't found which are the right steps to avoid this issues. Should I change NLS_LANG before import, should I let Oracle do the conversion...or what else ?
Thanks a lot
Francesco Received on Fri Feb 04 2005 - 03:41:35 CST