The MIMEHEADER_DECODE function decodes a string encoded in the MIME header format (RFC 2047) and returns the decoded string.
Applicability
This content applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support it.
Syntax
UTL_ENCODE.MIMEHEADER_DECODE (
buf IN VARCHAR2 CHARACTER SET ANY_CS)
RETURN VARCHAR2;
Parameters
Parameter |
Explanation |
|---|---|
| buf | The MIME header string to be decoded. The function automatically identifies the encoding charset and encoding method (Base64 or Quoted-printable). |
Return value
Return Value |
Description |
|---|---|
| VARCHAR2 | The decoded string, represented in the database character set. |