Product specifications

Data foundation data typeMS SQL Server OLE DB data type
XMLDBTYPE_XML
14.1.6 Oracle OCI
The following table lists the data types that show up through Oracle OCI and their equivalent in data
foundations.
Data foundation data typeOracle OCI data type
BINARYSQLT_BIN
LONGVARBINARYSQLT_BFILE, SQLT_BLOB, SQLT_LBI
TIMESTAMP
SQLT_DAT, SQLT_DATE, SQLT_TIME,
SQLT_TIMESTAMP, SQLT_TIMESTAMP_LTZ,
SQLT_TIMESTAMP_TZ
LONGVARCHARSQLT_CLOB, SQLT_LNG
DOUBLESQLT_FLT, SQLT_IBDOUBLE
REALSQLT_IBFLOAT
NUMERICSQLT_NUM
CHARSQLT_AFC
VARCHARSQLT_CHR, SQLT_RDD, SQLT_RID
2012-03-15187
Data type conversion reference