Exporting to a different character set.

From: Michael Burden <Michael.Burden_at_CGEY.COM>
Date: 12 Feb 2003 08:38:16 -0800
Message-ID: <3bbc0756.0302120838.bb77d2d@posting.google.com>

Hi,
I'm trying to export a table from a db with WE8ISO8859P15 characterset to a db with WE8ISO8859P1 characterset.

When I export the data I can set the NLS_LANG to convert to WE8ISO8859P1 but how do I convert the NCHAR columns which remain at WE8ISO8859P15. Using the unix command 'export NLS_NCHAR=WE8ISO8859P1' does not work.

Example export message

<<--start

Compress extents (yes/no): yes >

Export done in WE8ISO8859P1 character set and WE8ISO8859P15 NCHAR character set
server uses WE8ISO8859P15 character set (possible charset conversion)

About to export specified users ...

end -->>

When I try to load the data it does not like the WE8ISO8859P15 NCHAR character set.

This should be easy, shouldn't it? Received on Wed Feb 12 2003 - 10:38:16 CST