Home | Previous Page | Next Page   Data Types >

Built-In Data Types

Informix database servers support the following built-in data types.

Category Data Types
Character CHAR, CHARACTER VARYING, LVARCHAR, NCHAR, NVARCHAR, VARCHAR
Numeric DECIMAL, FLOAT, INT8, INTEGER, MONEY, SERIAL, SERIAL8, SMALLFLOAT, SMALLINT
Large-object Simple-large-object types: BYTE, TEXT Smart-large-object types: BLOB, CLOB
Time DATE, DATETIME, INTERVAL
Miscellaneous BOOLEAN

Extended Parallel Server does not support BLOB, CLOB, or LVARCHAR. For a description of character, numeric, and miscellaneous data types, refer to the appropriate entry in Description of Data Types. Page references are in the alphabetical list in Table 4.

Sections that follow provide additional information on large-object and time data types.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]