Product specifications

Data foundation data type
SQL type nameOracle JDBC data type
TIMESTAMPTIMESTAMPany value
DOUBLEany valueBINARY_DOUBLE
DOUBLEFLOATOTHER
REALany valueBINARY_FLOAT
CHARNCHARany value
VARCHAR
NVARCHAR2, ROWID,
UROWID
any value
14.1.4 ODBC
The following table lists the data types that show up through ODBC and their equivalent in data
foundations.
Data foundation data type
ODBC data type
BINARYSQL_BINARY
VARBINARYSQL_VARBINARY
LONGVARBINARYSQL_LONGVARBINARY
BITSQL_BIT
DATESQL_DATE, SQL_TYPE_DATE
2012-03-15182
Data type conversion reference