Character Data Types

Go Up to Specifying Data Types

InterBase supports four character string data types:

1. A fixed-length character data type, called CHAR(<n>) or CHARACTER(<n>), where <n> is the exact number of characters stored.
2. A variable-length character type, called VARCHAR(<n>) or CHARACTER VARYING(<n>), where <n> is the maximum number of characters in the string.
3. An NCHAR(<n>) or NATIONAL CHARACTER(<n>) or NATIONAL CHAR(<n>) data type, which is a fixed-length character string of <n> characters which uses the ISO8859_1 character set.
4. An NCHAR VARYING(<n>) or NATIONAL CHARACTER VARYING(<n>) or NATIONAL CHAR VARYING(<n>) data type, which is a variable-length national character string up to a maximum of <n> characters.

Topics

• Specifying a Character Set
• Fixed-length Character Data
• Variable-length Character Data

Advance To:

• Specifying a Character Set