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

Home -> Community -> Usenet -> c.d.o.server -> Re: Converting database from US7ASCII to UTF8

Re: Converting database from US7ASCII to UTF8

From: Joel Garry <joel-garry_at_home.com>
Date: 12 Dec 2005 13:16:31 -0800
Message-ID: <1134422191.205292.27630@g14g2000cwa.googlegroups.com>


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.html
Received on Mon Dec 12 2005 - 15:16:31 CST

Original text of this message

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