The CAST_TO_VARCHAR2 function converts a RAW value represented by a certain number of bytes to a VARCHAR2 value represented by the same number of bytes.
Note
When converting to VARCHAR2, the current globalization support character set applies to the characters in the VARCHAR2 value.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Syntax
UTL_RAW.CAST_TO_VARCHAR2 (
r IN RAW)
RETURN VARCHAR2;
Parameters
| Parameter | Description |
|---|---|
| r | The RAW data to be converted to VARCHAR2. |
Return value
| Return value | Description |
|---|---|
| RAW | The data in the input RAW value. |