The UTL_ENCODE system package is used to encode RAW data into a standard format so that the data can be transferred between hosts.
You can use UTL_ENCODE functions to encode the body of emails. The system package also provides decode functions that correspond to the encode functions. These functions comply with the encoding standards that have been published for compatibility with third-party applications on the sending or receiving ends.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Subprograms
The following table describes the UTL_ENCODE subprograms supported by the current OceanBase Database version.
| Subprogram | Description |
|---|---|
| BASE64_DECODE | Reads a Base64-encoded RAW input string and decodes it into its original RAW value. |
| BASE64_ENCODE | Encodes the binary representation of a RAW value into a Base64 RAW string and returns the string. |