Re: WE8ISO8859P1 convert to AL32UTF8 unicode character set question

I use convert function is to test becuase the result of convert is the same as importing the same string from a WE8ISO8859P1 database to a AL32UTF8 database. (From oracle document)

If the varchar2 can be converted to target characterset and can be converted back too. That means that the varchar2 can be converted successfully.

But as you said that when the char does not exist in db character set. It is one problem. It can cause unpredictable conversion.

Fortunately, we use jdbc program to operate on oracle db. Java is UTF-16 encoded, Data retrieved from or inserted into the database must be converted from UTF-16 to the database character set or the national character set and vice versa. (From oracle document)

Each character is converted from UTF-16 to WE8ISO8859P1. It also can be converted from WE8ISO8859P1 to UTF-16. Because UTF-16 can be converted to AL32UTF8, so all characters can be converted to AL32UTF8 characterset.

What do you think about?

I will test the way you metioned.

1. create one db with characterset WE8MSWIN1252, and insert data, and convert it.
2. create one db with characterset WE8ISO8859P1, and insert data, and alter database characterset to WE8MSWIN1252. Then convert it.

Thanks
Jacky Received on Wed Apr 08 2009 - 10:24:25 CDT