4 Replies Latest reply on Jun 17, 2019 7:52 AM by JackK

    UTL_RAW.cast_to_varchar2 and characterset

    JackK

      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?