Product specifications

Data foundation data type
DB2 ODBC data type
LONGVARBINARYSQL_BLOB
LONGVARCHAR
SQL_CLOB, SQL_DBCLOB, SQL_LONGVAR-
GRAPHIC
DOUBLESQL_DECFLOAT
CHARSQL_GRAPHIC
VARCHARSQL_VARGRAPHIC
XMLSQL_XML
IBM Informix
The following table lists the data types that could show up in results when the user queries an IBM
Informix database through ODBC, and their equivalent in data foundations. These data types overwrite
the generic ones.
Data foundation data type
Informix ODBC data type
SMALLINTSQL_BIT
LONGVARBINARYSQL_INFX_UDT_BLOB
It can be mapped to:
• DATE if the Informix data type follows the pattern
DATETIME\\s+(HOUR|MINUTE|SEC
OND)\\s+TO\\s+(HOUR|MINUTE|SECOND)
• TIME if the Informix data type follows the pattern DATE
TIME\\s+(YEAR|MONTH|DAY)\\s+TO\\s+(YEAR|MONTH|DAY)
• TIMESTAMP in the other cases
SQL_TIMESTAMP,
SQL_TYPE_TIMESTAMP
LONGVARCHARSQL_INFX_UDT_CLOB
2012-03-15184
Data type conversion reference