Product specifications

MS SQL Server
The following table lists the data types that could show up in results when the user queries an MS SQL
Server database through ODBC, and their equivalent in data foundations. These data types overwrite
the generic ones.
Data foundation data type
MS SQL Server ODBC data type
TIMESTAMPSQL_SS_TIME2, SQL_SS_TIMESTAMPOFFSET
XMLSQL_SS_XML
14.1.5 OLE DB
The following table lists the data types that show up through OLE DB and their equivalent in data
foundations.
Note:
For some data types, the mapping depends on the values of DBCOLUMNFLAGS_ISLONG and DBCOLUM
NFLAGS_ISFIXEDLENGTH parameters associated with each type.
Data foundation data typeOLE DB data type
VARBINARYDBTYPE_BYTES
LONGVAR_BINARY
DBTYPE_BYTES if DBCOLUMNFLAGS_ISLONG=true
BINARY
DBTYPE_BYTES if DBCOLUMNFLAGS_IS
FIXEDLENGTH=true
BITDBTYPE_BOOL
DATEDBTYPE_DBDATE
TIMEDBTYPE_DBTIME
TIMESTAMPDBTYPE_DBTIMESTAMP
2012-03-15185
Data type conversion reference