Data Type Mapping
Data Type Mappings
The driver maps types from the data source to the corresponding data type available in the schema. The table below documents these mappings.
Note: The driver supports reading user-defined data types (UDTs). If you have declared a procedure or function with parameters containing UDTs, the getProcedureColumns method (see Procedure Parameters) will return the name of the UDT as the "TYPE_NAME".
| TYPE_CHAR | VARCHAR |
| TYPE_VARCHAR2 | VARCHAR |
| TYPE_NCHAR | VARCHAR |
| TYPE_NVARCHAR2 | VARCHAR |
| TYPE_CLOB | CLOB |
| TYPE_NCLOB | VARCHAR |
| TYPE_LONG | VARCHAR |
| TYPE_NUMBER | DECIMAL |
| TYPE_DATE | TIMESTAMP |
| TYPE_TIMESTAMP | TIMESTAMP |
| TYPE_TIMESTAMP_WITH_TIMEZONE | TIMESTAMP |
| TYPE_TIMESTAMP_WITH_LOCAL_TIMEZONE | TIMESTAMP |
| TYPE_INTERVAL_YEAR_TO_MONTH | INTERVAL YEAR (YEAR PRECISION) TO MONTH |
| TYPE_INTERVAL_DAY_TO_SECOND | INTERVAL DAY (DAY PRECISION) TO SECOND (FRACTIONAL SECONDS PRECISION) |
| TYPE_BLOB | BLOB |
| TYPE_BFILE | BFILE |
| TYPE_RAW | BINARY |
| TYPE_ROWID | ROWID |
| TYPE_UROWID | UROWID |
| TYPE_BINARY_FLOAT | REAL |
| TYPE_BINARY_DOUBLE | FLOAT |