|
Informix
|
JDBC
|
ODBC
|
|
BLOB
|
BLOB
|
SQL_LONGVARBINARY
|
|
BOOLEAN
|
BIT
|
SQL_BIT
|
|
BYTE
|
LONGVARBINARY
|
SQL_LONGVARBINARY
|
|
CHAR
|
CHAR
|
SQL_CHAR
|
|
CLOB
|
CLOB
|
SQL_LONGVARCHAR or SQL_WLONGVARCHAR
|
|
DATE
|
DATE
|
SQL_TYPE_DATE
|
|
DATETIME YEAR TO SECOND
|
TIME
|
SQL_TYPE_TIMESTAMP
|
|
DATETIME YEAR TO DAY
|
DATE
|
SQL_TYPE_DATE
|
|
DATETIME HOUR TO SECOND
|
TIME
|
SQL_TYPE_TIME
|
|
DECIMAL
|
DECIMAL
|
SQL_DECIMAL
|
|
FLOAT
|
FLOAT
|
SQL_DOUBLE
|
|
INT8
|
BIGINT
|
SQL_BIGINT
|
|
INTEGER
|
INTEGER
|
SQL_INTEGER
|
|
MONEY
|
DECIMAL
|
SQL_DECIMAL
|
|
NCHAR
|
CHAR or NCHAR
|
SQL_CHAR or SQL_WCHAR
|
|
NVARCHAR
|
VARCHAR or NVARCHAR
|
SQL_VARCHAR
|
|
SERIAL
|
INTEGER
|
SQL_INTEGER
|
|
SERIAL8
|
BIGINT
|
SQL_BIGINT
|
|
SMALLFLOAT
|
REAL
|
SQL_REAL
|
|
SMALLINT
|
SMALLINT
|
SQL_SMALLINT
|
|
TEXT
|
LONGVARCHAR
|
SQL_LONGVARCHAR or SQL_WLONGVARCHAR
|
|
VARCHAR
|
VARCHAR
|
SQL_VARCHAR or SQL_WVARCHAR
|