Informix data type | Actuate SQL data type | Compiled to Informix data type | Informix data type limitations |
CHAR | VARCHAR | VARCHAR | Informix VARCHAR has a maximum length of 254 characters. |
CHARACTER VARYING | VARCHAR | VARCHAR | Informix VARCHAR has a maximum length of 254 characters. |
DATE | TIMESTAMP | DATETIME | |
DATETIME | TIMESTAMP | DATETIME | |
DECIMAL | DECIMAL | DECIMAL | The maximum number of significant digits (precision) for Informix DECIMAL is 32. |
FLOAT | DOUBLE | FLOAT | Informix FLOAT is 4-byte, not 8‑byte, floating point. The maximum number of significant digits (precision) is 16. |
INT8 | DECIMAL | DECIMAL | The maximum number of significant digits (precision) for Informix DECIMAL is 32. |
INTEGER | INTEGER | INTEGER | |
MONEY | DECIMAL | DECIMAL | The maximum number of significant digits (precision) for Informix DECIMAL is 32. |
SMALLFLOAT | DOUBLE | FLOAT | Informix FLOAT is 4-byte, not 8‑byte, floating point. The maximum number of significant digits (precision) is 16. |
SMALLINT | INTEGER | INTEGER | |
VARCHAR | VARCHAR | VARCHAR | Informix VARCHAR has a maximum length of 254 characters. |