The Informix database interfaces support the Informix datatypes listed in Table 8-1 in DataWindow objects and embedded SQL.
Blob |
LVarChar |
Boolean |
Money |
Byte (a maximum of 2^31 bytes) |
NChar |
Char |
NVarChar |
Clob |
Real |
Date |
Serial |
DateTime |
Serial8 |
Decimal |
SmallInt (2 bytes) |
Float |
Text (a maximum of 2^31 bytes) |
Int8 |
Time |
Integer (4 bytes) |
VarChar (1 to 255 bytes) |
Interval |
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.
