The CAST_TO_VARCHAR2 function converts a RAW value with a specific number of bytes into a VARCHAR2 value with the same number of bytes.
Note
During conversion into the VARCHAR2 value, the current Globalization Support character set is used for the characters in the VARCHAR2 value.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Syntax
UTL_RAW.CAST_TO_VARCHAR2 (
r IN RAW)
RETURN VARCHAR2;
Parameters
| Parameter | Description |
|---|---|
| r | The RAW value to be converted into a VARCHAR2 value. |
Return values
| Return value | Description |
|---|---|
| RAW | This value contains the same data of the input RAW. |