TEXT_ENCODE v17
Use the TEXT_ENCODE
function to translate a string to a user-specified character set and then encode the string. The signature is:
TEXT_DECODE(<buf> IN VARCHAR2, <encode_charset> IN VARCHAR2 DEFAULT NULL, <encoding> IN PLS_INTEGER DEFAULT NULL)
This function returns a VARCHAR2
value.
Parameters
buf
buf
contains the encoded string to translate to the specified character set and encode with TEXT_ENCODE
.
encode_charset
encode_charset
specifies the character set to which to translate the value before encoding. The default value is NULL
.
encoding
encoding
specifies the encoding type used by TEXT_ENCODE
. Specify:
UTL_ENCODE.BASE64
to specify base-64 encoding.UTL_ENCODE.QUOTED_PRINTABLE
to specify quoted printable encoding. This is the default.
Examples
This example uses the TEXT_ENCODE
and TEXT_DECODE
functions to first encode and then decode a string:
edb=# SELECT UTL_ENCODE.TEXT_ENCODE('What is the date?', 'BIG5', UTL_ENCODE.BASE64) FROM DUAL;
Output
text_encode -------------------------- V2hhdCBpcyB0aGUgZGF0ZT8= (1 row)
edb=# SELECT UTL_ENCODE.TEXT_DECODE('V2hhdCBpcyB0aGUgZGF0ZT8=', 'BIG5', UTL_ENCODE.BASE64) FROM DUAL;
Output
text_decode ------------------- What is the date? (1 row)
- On this page
- Parameters
- Examples