NVARCHAR2

From Oracle FAQ
Jump to: navigation, search

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

[edit] 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)
--------------
働 (どう はたら

[edit] Also see

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 #