UTL_ENCODE v16
The UTL_ENCODE package provides a way to encode and decode data. EDB Postgres 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 its 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. |
base64_decode base64_encode mimeheader_decode mimeheader_encode quoted_printable_decode quoted_printable_encode text_decode text_encode uudecode uuencode