The following table identifies the supported Informix 9 datatypes
and their corresponding ODBC datatypes.
Table B-2: Informix
datatypes and related 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.
