Database Software

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!

Possible to use ucs2 in convert() function?

cindyconlinOct 2 2007 — edited Oct 9 2007

Is it possible to use the convert() function to convert data from ucs2 to utf8?

I saw another post that said this could be done through OCI APIs, but I'd like to do it through the SQL convert function. Is this possible?

I tried to simulate this by doing a conversion from utf16 to utf8, using the statement:
select convert('É',UTF8, AL16UTF16) from dual;
but I received an "ORA-00911: invalid character" error when SQL*Plus encountered the accented E (codepoint C9). This was through SQL*Plus on a Linux box where my NLS_LANG was set to AMERICAN_AMERICA.UTF8.

I'd appreciate any ideas. Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 6 2007

Added on Oct 2 2007

#database-key-features, #globalization-support

6 comments

5,022 views