TO_NCHAR (character)

Purpose

This function converts data of the CHAR, VARCHAR2, CLOB, or NCLOB type to the national character set and returns the data as the NVARCHAR2 data type.

Syntax

TO_NCHAR(character)

Parameters

character specifies the data of the CHAR, VARCHAR2, CLOB, or NCLOB type.

Return type

NVARCHAR2.

Examples

Create a table named tbl1 and insert data into it. Then, convert the VARCHAR2 data in the tbl1 table to the national character set.

obclient> CREATE TABLE tbl1(col1 INT,col2 VARCHAR2(20));
Query OK, 0 rows affected

obclient> INSERT INTO tbl1 VALUES(1,'OceanBase');
Query OK, 1 row affected

obclient> SELECT TO_NCHAR(col2) FROM tbl1;
+----------------+
| TO_NCHAR(COL2) |
+----------------+
| OceanBase      |
+----------------+
1 row in set