QUOTED_PRINTABLE_DECODE v17
Use the QUOTED_PRINTABLE_DECODE
function to translate an encoded quoted-printable string into a decoded RAW
string.
The signature is:
QUOTED_PRINTABLE_DECODE(<r> IN RAW)
This function returns a RAW
value.
Parameters
r
r
contains the encoded string to decode. The string is a RAW
value encoded by QUOTED_PRINTABLE_ENCODE
.
Examples
Before executing the example, invoke the command:
SET bytea_output = escape;
This command escapes any nonprintable characters and displays BYTEA
or RAW
values onscreen in readable form. For more information, see the Postgres core documentation.
This example first encodes and then decodes a string:
edb=# SELECT UTL_ENCODE.QUOTED_PRINTABLE_ENCODE('E=mc2') FROM DUAL;
Output
quoted_printable_encode ------------------------- E=3Dmc2 (1 row)
edb=# SELECT UTL_ENCODE.QUOTED_PRINTABLE_DECODE('E=3Dmc2') FROM DUAL;
Output
quoted_printable_decode ------------------------- E=mc2 (1 row)
- On this page
- Parameters
- Examples