Supported Informix datatypes

The Informix database interface supports the Informix datatypes listed in Table 5-1 in DataWindow objects.

Table 5-1: Supported datatypes for Informix

Byte (a maximum of 231 bytes)

Integer (4 bytes)

Character (1 to 32,511 bytes)

Money

Date

Real

DateTime

Serial

Decimal

SmallInt (2 bytes)

Float

Text (a maximum of 231 bytes)

Interval

VarChar (1 to 255 bytes)

NoteExceptions Byte, text, and VarChar datatypes are not supported in Informix SE.