QUOTED_PRINTABLE_DECODE v16

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;

quoted_printable_encode
-------------------------
 E=3Dmc2
(1 row)

edb=# SELECT UTL_ENCODE.QUOTED_PRINTABLE_DECODE('E=3Dmc2') FROM DUAL;

 quoted_printable_decode
-------------------------
 E=mc2
(1 row)

• On this page
• Parameters
• Examples