Re: Question on Database CharacterSet

"Mr. M" wrote:

> Hi All,
>
> I would like to know if there is any method(s) to convert my Oracle DB to
> another new DB. My situation is:
>
> Current Database:
> (1) Oracle 8i running on WIndows XP.
> (2) Character set: "WE8ISO8859P1"
> (3) The setting of "Language for non-unicode Programs" is "Chinese (PRC)".
> The setting was made in "Control Panel" --> "Regional and Language
> Options" --> "Advanced" --> "Language for non-unicode Programs".
> (4) There are already Chinese character data input in the database which I
> think (but not sure) it's stored using GB code.
>
> New Database:
> (1) Oracle 8i running on WIndows XP.
> (2) Character set: "ZHT16BIG5"
> (3) The setting of "Language for non-unicode Programs" will be "Chinese
> (Taiwan)".
>
> How can I convert the existing DB so that the original data can be used in
> the new DB? I have already tried to export the current DB and import to the
> new DB but that doesn't work!
>
> Thanks.

You should consider UTF-8 for your database if storing multiple character sets.

Go to http://tahiti.oracle.com or search the google.com archives for comp.databases.oracle.server and you will find information on changing character stes in 8i.

Daniel Morgan Received on Mon Mar 10 2003 - 08:53:06 CET