Oracle->MySQL
Data Type (Oracle) |
Condition |
Data Type (MySQL) |
Whether to Support Mapping |
---|---|---|---|
CHAR |
length<=255 |
CHAR |
Yes |
CHAR |
length>255 |
VARCHAR |
Yes |
VARCHAR |
Length (row size) ≤ 65536 |
VARCHAR |
Yes |
VARCHAR |
Length (row 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 |
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.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot