Product specifications

Data foundation data typeJDBC data type
LONGVARBINARYBLOB, LONGVARBINARY
BITBIT, BOOLEAN
LONGVARCHARCLOB, NCLOB
DATEDATE
TIMETIME
TIMESTAMPTIMESTAMP
DOUBLEDOUBLE
FLOATFLOAT
REALREAL
SMALLINTSMALLINT
CHARCHAR, NCHAR
VARCHAR
LONGNVARCHAR, LONGVARCHAR, NVAR-
CHAR, ROWID, VARCHAR
XMLSQLXML
IBM Informix
The following table lists the data types that could show up in results when the user queries an IBM
Informix database through JDBC, and their equivalent in data foundations. These data types overwrite
the generic ones.
2012-03-15180
Data type conversion reference