The following table shows how the Informix data types are mapped to the standard ODBC data types.

Table 1. Informix Data Types
Informix ODBC
BLOB SQL_LONGVARBINARY
BOOLEAN SQL_BIT
BYTE SQL_LONGVARBINARY
CHAR SQL_CHAR
CLOB SQL_LONGVARCHAR
DATE SQL_TYPE_DATE
DATETIME YEAR TO FRACTION(f)1 SQL_TYPE_TIMESTAMP
DATETIME YEAR TO SECOND SQL_TYPE_TIMESTAMP
DATETIME YEAR TO DAY SQL_TYPE_DATE
DATETIME HOUR TO SECOND SQL_TYPE_TIME
DATETIME HOUR TO FRACTION(f)2 SQL_TYPE_TIME
DECIMAL SQL_DECIMAL
FLOAT SQL_DOUBLE
INT8 SQL_BIGINT
INTEGER SQL_INTEGER
INTERVAL YEAR(p) TO YEAR SQL_INTERVAL_YEAR
INTERVAL YEAR(p) TO MONTH SQL_INTERVAL_YEAR_TO_MONTH
INTERVAL MONTH(p) TO MONTH SQL_INTERVAL_MONTH
INTERVAL DAY(p) TO DAY SQL_INTERVAL_DAY
INTERVAL DAY(p) TO HOUR SQL_INTERVAL_DAY_TO_HOUR
INTERVAL DAY(p) TO MINUTE SQL_INTERVAL_DAY_TO_MINUTE
INTERVAL DAY(p) TO SECOND SQL_INTERVAL_DAY_TO_SECOND
INTERVAL DAY(p) TO FRACTION(f)3 SQL_INTERVAL_DAY_TO_SECOND
INTERVAL HOUR(p) TO HOUR SQL_INTERVAL_HOUR
INTERVAL HOUR(p) TO MINUTE SQL_INTERVAL_HOUR_TO_MINUTE
INTERVAL HOUR(p) TO SECOND SQL_INTERVAL_HOUR_TO_SECOND
INTERVAL HOUR(p) TO FRACTION(f)4 SQL_INTERVAL_HOUR_TO_SECOND
INTERVAL MINUTE(p) TO MINUTE SQL_INTERVAL_MINUTE
INTERVAL MINUTE(p) TO SECOND SQL_INTERVAL_MINUTE_TO_SECOND
INTERVAL MINUTE(p) TO FRACTION(f)5 SQL_INTERVAL_MINUTE_TO_SECOND
INTERVAL SECOND(p) TO SECOND SQL_INTERVAL_SECOND
INTERVAL SECOND(p) TO FRACTION(f)6 SQL_INTERVAL_SECOND
LVARCHAR(p) 7 SQL_VARCHAR
MONEY SQL_DECIMAL
NCHAR SQL_CHAR
NVARCHAR SQL_VARCHAR
SERIAL SQL_INTEGER
SERIAL8 SQL_BIGINT
SMALLFLOAT SQL_REAL
SMALLINT SQL_SMALLINT
TEXT SQL_LONGVARCHAR
VARCHAR SQL_VARCHAR

See Retrieving data type information for more information about data types.

1 (f) can have a value of 1, 2, 3, 4, or 5. The precision is type-dependent and the scale is 5.
2 (f) can have a value of 1, 2, 3, 4, or 5. The precision is type-dependent and the scale is 5.
3 (f) can have a value of 1, 2, 3, 4, or 5. The precision is type-dependent and the scale is 5.
4 (f) can have a value of 1, 2, 3, 4, or 5. The precision is type-dependent and the scale is 5.
5 (f) can have a value of 1, 2, 3, 4, or 5. The precision is type-dependent and the scale is 5.
6 (f) can have a value of 1, 2, 3, 4, or 5. The precision is type-dependent and the scale is 5.
7 Supported only on Informix 9.4 and higher servers.