Data types
- Last Updated: May 4, 2021
- 1 minute read
- DataDirect Connectors
- JDBC
- Oracle Database 6.0
- Documentation
The following table lists the data types supported by the Oracle driver and describes how they are mapped to the JDBC data types.
| Oracle Data Type | JDBC Data Type |
|---|---|
| BFILE | BLOB |
| BINARY_DOUBLE | DOUBLE |
| BINARY_FLOAT | REAL |
| BLOB | BLOB |
| CHAR | CHAR |
| CLOB | CLOB |
| DATE | TIMESTAMP |
| FLOAT(n) | DOUBLE |
| INTERVAL DAY TO SECOND | VARCHAR |
| INTERVAL YEAR TO MONTH | VARCHAR |
| LONG | LONGVARCHAR |
| LONG RAW | LONGVARBINARY |
| NCHAR | CHAR or NCHAR 1 |
| NCLOB | CLOB or NCLOB 2 |
| NUMBER | DECIMAL |
| NUMBER (p, s) | DECIMAL |
| NVARCHAR2 | VARCHAR or NVARCHAR 3 |
| OBJECT | STRUCT |
| RAW | VARBINARY |
| TABLE | ARRAY |
| TIMESTAMP | TIMESTAMP |
| TIMESTAMP WITH LOCAL TIME ZONE | TIMESTAMP |
| TIMESTAMP WITH TIME ZONE 4 | VARCHAR or TIMESTAMP |
| UROWID | VARCHAR |
| VARCHAR2 | VARCHAR |
| VARRAY | ARRAY |
| XMLType | CLOB or SQLXML 5 |
For More Information:
- See Using date/time data types for more information about the TIMESTAMP, TIMESTAMP WITH LOCAL TIME ZONE, and TIMESTAMP WITH TIME ZONE data types.
- See Using collection data types for more information about the VARRAY, TABLE, and OBJECT data types.
- See Returning and inserting/updating XML data for more information about the XMLType data type.
- See getTypeInfo for a description of the data types returned by the getTypeInfo() method.
1 When JDBCBehavior=
0, the second data type
applies.2 When JDBCBehavior=
0, the second data type
applies.3 When JDBCBehavior=
0, the second data type
applies.4 When FetchTSWTZasTimestamp=false (default), this data type is
mapped to the JDBC VARCHAR data type; when
FetchTSWTZasTimestamp=true, it is mapped to the JDBC TIMESTAMP data
type.
5 When JDBCBehavior=
0, the second data type
applies.