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!

UTL_RAW.cast_to_varchar2 and characterset

JackKJun 14 2019 — edited Jun 17 2019

Hello!

The DOC (https://docs.oracle.com/cd/B19306_01/appdev.102/b14258/u_raw.htm#BABJFGBH) says:

Note: When casting to a VARCHAR2, the current Globalization Support character set is used for the characters within that VARCHAR2.

Is there any way to use some other characterset?

I do need to write a BLOB which is UTF-8 encoded to a file (from Forms 6i) even if NLS_CHARACTERSET is not set to UTF8. How do I achive this?

I am using Oracle 11g.

Message was edited:

Or from the other side... How may I write to a file in Oracle Forms 6i byte by byte, means: not characters, but bytes?

This post has been answered by Solomon Yakobson on Jun 14 2019

Jump to Answer

Added on Jun 14 2019

#11g

4 comments

12,333 views