Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Import character set issue:

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US