Supported Informix
datatypes
The Informix database interfaces support the Informix datatypes
listed in the following table 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 section called “Datatypes” in PowerScript Reference.