NVARCHAR2 is a Unicode character data type. This topic describes the syntax, parameters, and usage of the NVARCHAR2 data type.
Syntax
NVARCHAR2(size)
Parameters
| Parameter | Description |
|---|---|
| size | The length of the column, which is variable-length. size specifies the number of characters. The total size of size characters cannot exceed 32767 bytes. You must specify the size for NVARCHAR2. For AL16UTF16 encoding, the maximum number of bytes is twice the size. For UTF8 encoding, the maximum number of bytes is three times the size. The maximum number of bytes is defined by the national character set and cannot exceed 32767 bytes. |
Considerations
The length of an NVARCHAR2 column is variable, with a maximum storage length of 32767 bytes and a minimum of 1 byte. When creating a table that contains an NVARCHAR2 column, you must specify the maximum number of characters that can be stored in the NVARCHAR2 column. The default unit is CHAR, and you cannot manually specify other units.
If you are unsure about the length of the data to be stored and the data may contain Chinese characters, you can choose the NVARCHAR2 data type.