The following table lists the data types supported by the Informix driver and how they are mapped to the JDBC data types.

Table 1. Informix Data Types
Informix Data Type JDBC Data Type
BLOB BLOB
BOOLEAN BOOLEAN
BYTE LONGVARBINARY
CHAR CHAR
CLOB CLOB
DATE DATE
DATETIME HOUR TO SECOND TIME
DATETIME YEAR TO DAY DATE
DATETIME YEAR TO FRACTION(5) TIMESTAMP
DATETIME YEAR TO SECOND TIMESTAMP
DECIMAL DECIMAL
FLOAT FLOAT
INT8 BIGINT
INTEGER INTEGER
LVARCHAR VARCHAR
MONEY DECIMAL
NCHAR CHAR or NCHAR 1
NVARCHAR VARCHAR or NVARCHAR 2
SERIAL INTEGER
SERIAL8 BIGINT
SMALLFLOAT REAL
SMALLINT SMALLINT
TEXT LONGVARCHAR
VARCHAR VARCHAR
1 When JDBCBehavior=1, the first value applies and when JDBCBehavior=0, the second value applies.
2 When JDBCBehavior=1, the first value applies and when JDBCBehavior=0, the second value applies.