Varchar

Restriction: This topic applies to Windows environments only.

VARCHAR (field-length)

This data type consists of variable length alphanumeric string values with a maximum length of field-length characters. field-length must be a positive number not exceeding 32,706. See the CREATE TABLE command for more information on determining lengths of VARCHAR and LONG VARCHAR variables. Can be defined as FOR BIT DATA. If the column is specified as NOT NULL WITH DEFAULT, null values will be replaced by spaces.

Note: Currently all varchar and vargraphic fields are stored as fixed length fields. In future releases the storage required for these field types will vary according to the data to be stored.