This topic describes the compatibility of OceanBase Database in Oracle mode with native Oracle Database in terms of SQL data types.
Oracle Database supports 24 data types, while OceanBase Database supports 18. The following table lists the data types.
| No. | Oracle data type | Supported in OceanBase Database |
|---|---|---|
| 1 | VARCHAR2(size) | Yes |
| 2 | NVARCHAR2(size) | Yes |
| 3 | NUMBER [ (p [, s]) ] | Yes |
| 4 | FLOAT [(p)] | Yes |
| 5 | LONG (deprecated type in Oracle Database) | No |
| 6 | DATE | Yes |
| 7 | BINARY_FLOAT | Yes |
| 8 | BINARY_DOUBLE | Yes |
| 9 | TIMESTAMP [(fractional_seconds_precision)] | Yes |
| 10 | TIMESTAMP [(fractional_seconds_precision)] WITH TIME ZONE | Yes |
| 11 | TIMESTAMP [(fractional_seconds_precision)] WITH LOCAL TIME ZONE | Yes |
| 12 | INTERVAL YEAR [(year_precision)] TO MONTH | Yes |
| 13 | INTERVAL DAY [(day_precision)] TO SECOND [(fractional_seconds_precision)] | Yes |
| 14 | RAW(size) | Yes |
| 15 | LONG RAW (deprecated type in Oracle Database) | No |
| 16 | ROWID | Yes |
| 17 | UROWID [(size)] | Yes |
| 18 | CHAR (size) | Yes |
| 19 | NCHAR[(size)] | Yes |
| 20 | CLOB | Yes |
| 21 | NCLOB | No |
| 22 | BLOB | Yes |
| 23 | BFILE | No |