SQL & PL/SQL

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!

9.2 convert ASCII to UTF8 welsh language

536438Dec 15 2006 — edited Dec 21 2006

hello

I have a 9.2 ascii database that i cant convert to UTF8 yet

1 for an output (util file) i need to convert an ascii text string to utf-8 on export

2 i have two characters that are not supported by ascii, ŵŷ the users will represent these by typing w^y^

I tryed using UNISTR but non of the characters below are corectly converted

SELECT UNISTR(ASCIISTR( 'ÂâîÊêô)) FROM DUAL ;

how would you recomend converting a ascii latin 1 extended string to UTF-8 for export?

is it sencible to use the character replacement plan above for ŵŷ?

thanks

james

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 18 2007

Added on Dec 15 2006

9 comments

2,163 views