Supported Informix datatypes

The Informix database interface supports the Informix datatypes listed in Table 6-1 in DataWindow objects and embedded SQL.

**Table 6-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)

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

Datatype conversion When you retrieve or update columns, PowerBuilder converts data appropriately between the Informix datatype and the PowerScript datatype. Keep in mind, however, that similarly or identically named Informix and PowerScript datatypes do not necessarily have the same definitions.

For information about the definitions of PowerScript datatypes, see the PowerScript Reference.