Oracle->TaurusDB
| Data Type (Oracle) | Condition | Data Type (TaurusDB) | Whether to Support Mapping |
|---|---|---|---|
| CHAR | length<=255 | CHAR | Yes |
| CHAR | length>255 | VARCHAR | Yes |
| VARCHAR | Size<=65536 | VARCHAR | Yes |
| VARCHAR | Size>65536 | TEXT | Yes |
| VARCHAR2 | - | VARCHAR2 | Yes |
| NCHAR | length<=255 | NCHAR | Yes |
| NCHAR | length>255 | NVARCHAR | Yes |
| NVARCHAR2 | - | NVARCHAR | Yes |
| NUMBER | precision=0 scale = 0 | DECIMAL(65,30) | Yes |
| NUMBER | precision!=0 scale!=0 | DECIMAL(precision, scale) | Yes |
| FLOAT | - | FLOAT | Yes |
| BINARY_FLOAT | - | FLOAT | Yes |
| BINARY_DOUBLE | - | DOUBLE | Yes |
| DATE | - | DATETIME | Yes |
| TIMESTAMP | If the precision of the source database exceeds 6 digits, the precision will be reduced to 6 digits due to the maximum precision allowed in the destination database. | DATETIME | Yes |
| TIMESTAMP WITH TIME ZONE | If the precision of the source database exceeds 6 digits, the precision will be reduced to 6 digits due to the maximum precision allowed in the destination database. | TIMESTAMP | Yes |
| TIMESTAMP WITH LOCAL TIME ZONE | If the precision of the source database exceeds 6 digits, the precision will be reduced to 6 digits due to the maximum precision allowed in the destination database. | TIMESTAMP | Yes |
| INTERVAL | Incremental | VARCHAR(30) | No |
| INTERVAL | Full; 6 digit precision | VARCHAR(30) | Yes |
| BLOB | - | LONGBLOB | Yes |
| CLOB | - | LONGTEXT | Yes |
| NCLOB | - | LONGTEXT | Yes |
| LONG | - | LONGTEXT | Yes |
| RAW | - | VARBINARY | Yes |
| LONG RAW | - | LONGBLOB | Yes |
| ROWID | - | VARCHAR(18) | Yes |
| UROWID | - | - | No |
| XMLTYPE | - | LONGTEXT | Yes |
| BFILE | - | - | No |
| SDO_GEOMETRY | - | - | No |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
