The following table identifies the supported Informix 9 datatypes and their corresponding ODBC datatypes.
Informix 9 datatypes |
ODBC datatypes |
|---|---|
CHAR |
SQL_CHAR(1) |
NCHAR |
SQL_CHAR(1) |
VARCHAR |
SQL_VARCHAR(12) |
NVARCHAR |
SQL_VARCHAR(12) |
LVARCHAR |
SQL_VARCHAR(12) |
*TEXT |
SQL_LONGVARCHAR(-1) |
*BYTE |
SQL_LONGVARBINARY(-4) |
BOOLEAN |
SQL_BIT(-7) |
INT8 |
SQL_BIGINT(-5) |
SERIAL8 |
SQL_BIGINT(-5) |
*BLOB |
SQL_LONGVARBINARY(-4) |
*CLOB |
SQL_LONGVARCHAR(-1) |
DECIMAL |
SQL_DECIMAL(3) |
MONEY |
SQL_DECIMAL(3) |
SMALLINT |
SQL_SMALLINT(5) |
INTEGER |
SQL_INTEGER(4) |
SERIAL |
SQL_INTEGER(4) |
FLOAT |
SQL_DOUBLE(8) |
SMALLFLOAT (4) |
SQL_REAL(7) |
DATE |
SQL_TYPE_DATE(91) |
DATETIME YEAR TO DAY |
SQL_TYPE_DATE(91) |
DATETIME HOUR TO SECOND |
SQL_TYPE_TIME(92) |
DATETIME HOUR TO FRACTION(5) |
SQL-TYPE_TIME(92) |
DATETIME YEAR TO SECOND |
SQL_TYPE_TIMESTAMP(93) |
INTERVAL YEAR() TO YEAR |
SQL_INTERVAL_YEAR(101) |
INTERVAL MONTH() TO MONTH |
SQL_INTERVAL_MONTH(102) |
INTERVAL DAY() TO DAY |
SQL_INTERVAL_DAY(103) |
INTERVAL HOUR() TO HOUR |
SQL_INTERVAL_HOUR(104) |
INTERVAL MINUTE() TO MINUTE |
SQL_INTERVAL_MINUTE(105) |
INTERVAL SECOND() TO SECOND |
SQL_INTERVAL_SECOND(106) |
INTERVAL SECOND() TO FRACTION(5) |
SQL_INTERVAL_SECOND(106) |
INTERVAL FRACTION TO FRACTION(5) |
SQL_INTERVAL_SECOND(106) |
INTERVAL YEAR() TO MONTH |
SQL_INTERVAL_YEAR_TO_MONTH(107) |
INTERVAL DAY() TO HOUR |
SQL_INTERVAL_DAY_TO_HOUR(108) |
INTERVAL DAY() TO MINUTE |
SQL_INTERVAL_DAY_TO_MINUTE(109) |
INTERVAL DAY() TO SECOND |
SQL_INTERVAL_DAY_TO_SECOND(110) |
INTERVAL DAY() TO FRACTION(5) |
SQL_INTERVAL_DAY_TO_SECOND(110) |
INTERVAL HOUR() TO MINUTE |
SQL_INTERVAL_HOUR_TO_MINUTE(111) |
INTERVAL HOUR() TO SECOND |
SQL_INTERVAL_HOUR_TO_SECOND(112) |
INTERVAL HOUR() TO FRACTION(5) |
SQL_INTERVAL_HOUR_TO_SECOND(112) |
INTERVAL MINUTE() TO SECOND |
SQL_INTERVAL_MINUTE_TO_SECOND(113) |
INTERVAL MINUTE() TO FRACTION(5) |
SQL_INTERVAL_MINUTE_TO_SECOND(113) |
* Results sets containing these datatypes are truncated to 32,768 bytes.
