Show TOC

Character StringLocate this document in the navigation structure

Definition

A character string is a data type (data_type) that consists of a series of alphanumeric characters.

Examples of data types that can be selected for character strings: CHAR[ACTER], VARCHAR, DATE, TIME, TIMESTAMP. In a column definition, a code attribute can be entered for the data types CHAR[ACTER] and VARCHAR.

The following comparison options exist for data types CHAR[ACTER] and VARCHAR:

Character strings with the same code attribute

These character strings can be compared to each other.

Character strings with the code attributes ASCII or UNICODE

These character strings are comparable with the character strings of code attributes ASCII or UNICODE and with data, time, and timestamp values.
More Information