Informix Data Type | JDBC Data Type |
BLOB | BLOB |
BOOLEAN | BIT |
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 |