CHARACTER VARYING - String with a variable length

You use the data type CHARACTER VARYING or VARCHAR for columns that can store alphanumeric values of a variable length (see section "Alphanumeric literals").

---

{ CHAR[ACTER] VARYING( max ) | VARCHAR( max ) }

---

max

Unsigned integer between 1 and 32 000 that defines the maximum length of the VARCHAR column.

Range of values for VARCHAR columns

A VARCHAR column can contain alphanumeric values of any length that are less than or equal to the specified maximum length.

Example

You define a VARCHAR column description that can store alphanumeric values with a maximum length of 1000 characters as follows:

description VARCHAR(1000)