NVARCHAR2
From Oracle FAQ
NVARCHAR2 is a data type used to store variable-length NLS or multibyte character set data.
Example[edit]
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[edit]
| 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 | # |
