skip to main content
Supported data types : Informix data types
 

Try DataDirect Cloud Now

Informix data types

The following table shows how the Informix data types are mapped to the standard data types for ODBC and JDBC.
Table 7. Informix data types
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