Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Converting database from US7ASCII to UTF8
The database can store 8 bit characters, even if you are using a 7 bit
ASCII characterset, if the tool you use to insert the characters allows
it, which most do.
exp/imp "helpfully" handles translations between character sets. So, if you tell it that it exported a 7 bit set, and is importing into an 8 bit set, it will likely truncate that extra bit.
See
http://groups.google.com/group/comp.databases.oracle.server/msg/f42c6ad1f2aa0466?dmode=source&hl=en
and look at the docs about NLS and character set conversion on
metalink, as well as search asktom.oracle.com for "exp imp characterset
conversion" (without the quotes). You basically want to fool oracle
into not doing the conversion.
jg
-- @home.com is bogus. http://www.signonsandiego.com/uniontrib/20051210/news_1b10zubkis.htmlReceived on Mon Dec 12 2005 - 15:16:31 CST