Informix Data Type | TDV Data Type |
BLOB | BLOB |
BOOLEAN | BOOLEAN (See Mapping of Native to TDV Data Types Across TDV Versions.) |
BYTE | VARBINARY |
CHAR | CHAR |
CHARACTER | CHAR |
CLOB | CLOB |
DATE | DATE |
DATETIME | TIMESTAMP |
DEC | DECIMAL |
DECIMAL | DECIMAL |
DOUBLE PRECISION | DOUBLE |
FLOAT | DOUBLE |
INT | INTEGER |
INT8 | LONG |
INTEGER | INTEGER |
LVARCHAR | CLOB |
MONEY | DECIMAL |
NCHAR | CHAR |
NULL | NULL |
NUMERIC | NUMERIC |
NVARCHAR | VARCHAR |
REAL | REAL |
SERIAL | INTEGER |
SERIAL8 | LONG |
SMALLFLOAT | FLOAT |
SMALLINT | SMALLINT |
TEXT | CLOB |
VARCHAR | VARCHAR |