> ### Informix

> The following table lists the data types that the ODBC driver supports for Informix:

> Table B-2. Mapping Informix Data Types to ODBC Data Types
> Informix Data Type | ODBC Data Type
> --- | ---
> BLOB | SQL_LONGVARBINARY
> BOOLEAN | SQL_BIT
> BYTE | SQL_LONGVARBINARY
> CHAR | SQL_CHAR
> CLOB | SQL_LONGVARCHAR
> DATE | SQL__TYPE_DATE
> DATETIME HOUR TO SECOND | SQL__TYPE_TIME
> DATETIME YEAR TO FRACTION(5) | SQL__TYPE_TIMESTAMP
> DECIMAL | SQL_DECIMAL
> FLOAT | SQL_FLOAT
> INTEGER | SQL_INTEGER
> INT8 | SQL_BIGINT
> LVARCHAR | SQL_LONGVARCHAR
> MONEY | SQL_DECIMAL
> NUMERIC | SQL_NUMERIC
> SERIAL | SQL_INTEGER
> SERIAL8 | SQL_BIGINT
> SMALLFLOAT | SQL_REAL
> SMALLINT | SQL_SMALLINT
> TEXT | SQL_LONGVARCHAR
> VARCHAR | SQL_VARCHAR