SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Display of Chinese characters / Conversion between AL16UTF16 and UTF8

549064Dec 5 2006 — edited Oct 3 2007

Hi all,

I have a view with NVARCHAR2 fields containing chinese characters. The encoding for these is AL16UTF16. A simple "SELECT <my_col> FROM <view_name>" correctly displays the chinese characters.

Anyway, I need to make a conversion for extraction purposes. I'd like to convert to UTF8.
But using the following statement did not work:

SELECT CONVERT(<my_col>, 'UTF8')

The characters were garbled.

I also tried

SELECT CONVERT(<my_col>, 'UTF8', 'AL16UTF16')
SELECT CONVERT(<my_col>, 'AL32UTF8')
SELECT CONVERT(<my_col>, 'AL32UTF8', 'AL16UTF16')

... but no success; some characters are still replaced by a rectangle.

I am using SQL Developer 1.0.0.15.57.

Any idea, why the conversion does not really function? Or might it be a problem of the SQL Developer?

Thanks to any answer in advance!

Best regards,
Philipp

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 31 2007

Added on Dec 5 2006

#sql-developer

4 comments

3,215 views