skip to main content
Part 3: The 32-Bit Drivers : The Informix Driver : Data Types
  
Data Types
The following table shows how the Informix data types map to the standard ODBC data types.
Table 50. Informix Data Types
Informix
ODBC
BLOB
SQL_LONGVARBINARY
BOOLEAN
SQL_BIT
BYTE 1
SQL_LONGVARBINARY
CHAR
SQL_CHAR
CLOB
SQL_LONGVARCHAR
DATE
SQL_TYPE_DATE
DATETIME YEAR TO FRACTION(f) 2
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)3
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)4
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)5
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)6
SQL_INTERVAL_MINUTE_TO_SECOND
INTERVAL SECOND(p) TO SECOND
SQL_INTERVAL_SECOND
INTERVAL SECOND(p) TO FRACTION(f)7
SQL_INTERVAL_SECOND
INTERVAL FRACTION TO FRACTION(f)2
SQL_INTERVAL_SECOND
LVARCHAR(p)8
SQL_VARCHAR
MONEY
SQL_DECIMAL
NCHAR
SQL_CHAR
NVARCHAR
SQL_VARCHAR
SERIAL
SQL_INTEGER
SERIAL8
SQL_BIGINT
SMALLFLOAT
SQL_REAL
SMALLINT
SQL_SMALLINT
TEXT9
SQL_LONGVARCHAR
VARCHAR10
SQL_VARCHAR
1 Not supported for Standard Engine databases.

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 (f) can have a value of 1, 2, 3, 4, or 5. The precision is type-dependent and the scale is 5.

8 (f) can have a value of 1, 2, 3, 4, or 5. The precision is type-dependent and the scale is 5.

9 Not supported for Standard Engine databases.

10 Not supported for Standard Engine databases.

The Informix driver does not support any complex data types (for example, set, multiset, list, and named/unnamed abstract types). When the driver encounters a complex type it will return an Unknown Data Type error (SQL State HY000).
See Retrieving Data Type Information for information about retrieving data types.