NATIONAL CHARACTER VARYING - Strings with a variable length

The data type NATIONAL CHARACTER VARYING or NVARCHAR is used for columns which can contain national values (see the section "National literals") with a variable length.

---

{ NATIONAL CHAR[ACTER] VARYING | NCHAR VARYING | NVARCHAR }( cu_max [CODE_UNITS])

---

cu_max

Unsigned integer between 1 and 16000 that defines the maximum length of the NVARCHAR columns in code units.

In SESAM/SQL the encoding form UTF-16 in which each code unit consists of 2 bytes is used for Unicode strings.

Range of values for NVARCHAR columns

An NVARCHAR column can contain national values of any length which are less than or equal to the specified maximum length.

Example

You define an NVARCHAR column description_in_Greek which can contain national values with a maximum length of 1000 characters as follows:

description_in_Greek NVARCHAR(1000)