Product specifications

Data foundation data typeOLE DB data type
DECIMALDBTYPE_DECIMAL
TINYINTDBTYPE_I1, DBTYPE_UI1
SMALLINTDBTYPE_I2, DBTYPE_UI2
INTEGERDBTYPE_I4, DBTYPE_UI4
BIGINTDBTYPE_I8, DBTYPE_UI8
REALDBTYPE_R4
DOUBLEDBTYPE_R8
NUMERICDBTYPE_CY, DBTYPE_NUMERIC
VARCHARDBTYPE_STR, DBTYPE_WSTR
LONGVARCHAR
DBTYPE_STR, DBTYPE_WSTR if DBCOLUMN
FLAGS_ISLONG=true
CHAR
DBTYPE_STR, DBTYPE_WSTR if DBCOLUMN
FLAGS_ISFIXEDLENGTH=true
MS SQL Server data types
The following table shows the data types that could show up in results when the user queries an MS
SQL Server database through OLE DB, and their equivalent in data foundations. These data types
overwrite the previous ones.
Data foundation data typeMS SQL Server OLE DB data type
TIMESTAMP
DBTYPE_DBTIME2, DBTYPE_DBTIMESTAM-
POFFSET
CHARDBTYPE_GUID
2012-03-15186
Data type conversion reference