UTL_ENCODE v14

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

Function/procedureReturn typeDescription
BASE64_DECODE(r)RAWUse the BASE64_DECODE function to translate a Base64 encoded string to the original RAW value.
BASE64_ENCODE(r)RAWUse the BASE64_ENCODE function to translate a RAW string to an encoded Base64 value.
BASE64_ENCODE(loid)TEXTUse the BASE64_ENCODE function to translate a TEXT string to an encoded Base64 value.
MIMEHEADER_DECODE(buf)VARCHAR2Use the MIMEHEADER_DECODE function to translate an encoded MIMEHEADER formatted string to its original value.
MIMEHEADER_ENCODE(buf, encode_charset, encoding)VARCHAR2Use the MIMEHEADER_ENCODE function to convert and encode a string in MIMEHEADER format.
QUOTED_PRINTABLE_DECODE(r)RAWUse the QUOTED_PRINTABLE_DECODE function to translate an encoded string to a RAW value.
QUOTED_PRINTABLE_ENCODE(r)RAWUse the QUOTED_PRINTABLE_ENCODE function to translate an input string to a quoted-printable formatted RAW value.
TEXT_DECODE(buf, encode_charset, encoding)VARCHAR2Use the TEXT_DECODE function to decode a string encoded by TEXT_ENCODE.
TEXT_ENCODE(buf, encode_charset, encoding)VARCHAR2Use the TEXT_ENCODE function to translate a string to a user-specified character set, and then encode the string.
UUDECODE(r)RAWUse the UUDECODE function to translate a uuencode encoded string to a RAW value.
UUENCODE(r, type, filename, permission)RAWUse the UUENCODE function to translate a RAW string to an encoded uuencode value.

base64_decode base64_encode mimeheader_decode mimeheader_encode quoted_printable_decode quoted_printable_encode text_decode text_encode uudecode uuencode