Data type mapping between Informix® and JDBC data types
Because there are variations between the SQL data types supported by each database vendor, the JDBC API defines a set of generic SQL data types in the class java.sql.Types. Use these JDBC API data types to reference generic SQL types in your Java™ programs that use the JDBC API to connect to HCL Informix® databases.
The following table shows the Informix® data type to which each JDBC API data type maps.
| JDBC API data type | Informix® data type |
|---|---|
| BIGINT | INT8, BIGINT, BIGSERIAL |
| BINARY | BYTE |
| BIT 1 | BOOLEAN |
| REF | Not supported |
| CHAR | CHAR(n) |
| DATE | DATE |
| DECIMAL | DECIMAL |
| DOUBLE | FLOAT |
| FLOAT | FLOAT2 |
| INTEGER | INTEGER |
| LONGVARBINARY | BYTE or BLOB |
| LONGVARCHAR | TEXT or CLOB |
| NUMERIC | DECIMAL |
| NUMERIC | MONEY |
| REAL | SMALLFLOAT |
| SMALLINT | SMALLINT |
| TIME | DATETIME HOUR TO SECOND2 |
| TIMESTAMP | DATETIME YEAR TO FRACTION(5)3 |
| TINYINT | SMALLINT |
| VARBINARY | BYTE |
| VARCHAR | VARCHAR(m,r) |
| BOOLEAN | BOOLEAN |
1 With Java™ 1.4 is , java.sql.Types.BOOLEAN maps to BOOLEAN.
2 This mapping is JDBC compliant. You can map the JDBC FLOAT data type to the Informix® SMALLFLOAT data type for backward compatibility by setting the IFX_SET_FLOAT_AS_SMFLOAT environment variable to 1.
3 Informix® DATETIME types are very restrictive and are not interchangeable. For more information, see Field lengths and date-time data.