| BLOB
|
BLOB
|
| CHAR
|
CHAR
|
| CLOB
|
CLOB
|
| DATE
|
TIMESTAMP
|
| FLOAT(n)
|
DOUBLE
|
| LONG
|
LONGVARCHAR
|
| LONG RAW
|
LONGVARBINARY
|
| NCHAR
|
CHAR or NCHAR
Note: When JDBCBehavior=0, this data type depends on the JVM used by the application. For JVMs earlier than Java SE 6, the first value applies. For Java SE 6 and later versions, the second value applies.
|
| NCLOB
|
CLOB or NCLOB
Note: When JDBCBehavior=0, this data type depends on the JVM used by the application. For JVMs earlier than Java SE 6, the first value applies. For Java SE 6 and later versions, the second value applies.
|
| NUMBER
|
DECIMAL
|
| NUMBER(p, s)
|
DECIMAL
|
| NVARCHAR2
|
VARCHAR or NVARCHAR
Note: When JDBCBehavior=0, this data type depends on the JVM used by the application. For JVMs earlier than Java SE 6, the first value applies. For Java SE 6 and later versions, the second value applies.
|
| RAW
|
VARBINARY
|
TIMESTAMP
Note: Supported only for Oracle 9i and later versions.
|
TIMESTAMP
|
TIMESTAMP WITH LOCAL TIMEZONE
Note: Supported only for Oracle 9i and later versions.
|
TIMESTAMP
|
TIMESTAMP WITH TIMEZONE
Note: Supported only for Oracle 9i and later versions.
Note: When FetchTSWTSasTimestamp=false (default), this data type is mapped to the JDBC VARCHAR data type; when FetchTSWTSasTimestamp=true, it is mapped to the JDBC TIMESTAMP data type.
|
VARCHAR or TIMESTAMP
|
VARCHAR2
Note: Supported only for Oracle 9i and later versions.
|
VARCHAR
|
| XMLType
|
CLOB or SQLXM
Note: When JDBCBehavior=0, this data type depends on the JVM used by the application. For JVMs earlier than Java SE 6, the first value applies. For Java SE 6 and later versions, the second value applies.
|
