UTL_ENCODE

The UTL_ENCODE package provides a way to encode and decode data. Advanced Server supports the following functions and procedures:

Function/Procedure

Return Type

Description

BASE64_DECODE(r)

RAW

Use the BASE64_DECODE function to translate a Base64 encoded string to the original RAW value.

BASE64_ENCODE(r)

RAW

Use the BASE64_ENCODE function to translate a RAW string to an encoded Base64 value.

BASE64_ENCODE(loid)

TEXT

Use the BASE64_ENCODE function to translate a TEXT string to an encoded Base64 value.

MIMEHEADER_DECODE(buf)

VARCHAR2

Use the MIMEHEADER_DECODE function to translate an encoded MIMEHEADER formatted string to it’s original value.

MIMEHEADER_ENCODE(buf, encode_charset, encoding)

VARCHAR2

Use the MIMEHEADER_ENCODE function to convert and encode a string in MIMEHEADER format.

QUOTED_PRINTABLE_DECODE(r)

RAW

Use the QUOTED_PRINTABLE_DECODE function to translate an encoded string to a RAW value.

QUOTED_PRINTABLE_ENCODE(r)

RAW

Use the QUOTED_PRINTABLE_ENCODE function to translate an input string to a quoted-printable formatted RAW value.

TEXT_DECODE(buf, encode_charset, encoding)

VARCHAR2

Use the TEXT_DECODE function to decode a string encoded by TEXT_ENCODE.

TEXT_ENCODE(buf, encode_charset, encoding)

VARCHAR2

Use the TEXT_ENCODE function to translate a string to a user-specified character set, and then encode the string.

UUDECODE(r)

RAW

Use the UUDECODE function to translate a uuencode encoded string to a RAW value.

UUENCODE(r, type, filename, permission)

RAW

Use the UUENCODE function to translate a RAW string to an encoded uuencode value.