NVARCHAR2

NVARCHAR2 is a data type used to store variable-length NLS or multibyte character set data.

Example

SQL> CREATE TABLE nvarchar2_test (col1 NVARCHAR2(10));

Table created.

SQL> INSERT INTO nvarchar2_test VALUES ( N'qwerty' );

1 row created.

For Oracle 9 and greater, you can use the to_nchar function. Below inserts Kanji (JP) characters

SQL> INSERT into nvarchar2_test values (to_nchar('働 (どう はたら'))

1 row created.

SQL> SELECT to_nchar(col1) from nvarchar2_test

TO_NCHAR(COL1)
--------------
働 (どう はたら

Also see

• VARCHAR
• NCLOB
• NCHAR

Glossary of Terms
A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	#