Product specifications

Data foundation data type
ODBC data type
TIMESTAMP
SQL_DATETIME, SQL_TIME, SQL_TIMESTAMP,
SQL_TYPE_TIME, SQL_TYPE_TIMESTAMP
LONGVARCHARSQL_LONGVARCHAR, SQL_WLONGVARCHAR
BIGINTSQL_BIGINT
DECIMALSQL_DECIMAL
DOUBLESQL_DOUBLE
FLOATSQL_FLOAT
INTEGERSQL_INTEGER
NUMERICSQL_NUMERIC
REALSQL_REAL
SMALLINTSQL_SMALLINT
TINYINTSQL_TINYINT
CHARSQL_CHAR, SQL_GUID, SQL_WCHAR
VARCHARSQL_VARCHAR, SQL_WVARCHAR
IBM DB2
The following table lists the data types that could show up in results when the user queries an IBM DB2
database through ODBC, and their equivalent in data foundations. These data types overwrite the
generic ones.
2012-03-15183
Data type conversion reference