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!

Converting a character to a raw UTF-32/UCS-4 value

J. Fuda-OracleAug 26 2011 — edited Aug 26 2011

Hi,

Is there any way to convert a character currently stored in the database character set to a UTF-32/UCS-4 raw value? This function

UTL_I18N.STRING_TO_RAW(
   data          IN VARCHAR2 CHARACTER SET ANY_CS,
   dst_charset   IN VARCHAR2 DEFAULT NULL)
RETURN RAW;

looks like it could do the job but I couldn't find a UTF-32/UCS-4 character set in the Globalization Support Guide's [Character Sets|http://download.oracle.com/docs/cd/E11882_01/server.112/e10729/applocaledata.htm#i635016] chapter to use for the "dst_charset" parameter.

There is some text in the manual pages for functions like LENGTH4 and SUBSTR4 indicating that these functions "use UCS4 code points" so it looks like Oracle does have some sort of UCS-4 support even if it doesn't have a UCS-4 character set.

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 23 2011

Added on Aug 26 2011

#database-key-features, #globalization-support

1 comment

380 views