Help Center/ Data Replication Service/ Service Overview/ Mapping Data Types/ MySQL->Oracle

Updated on 2022-12-29 GMT+08:00

View PDF

MySQL->Oracle

**Table 1** Data type mapping
Data Type (MySQL)	Data Type (Oracle)	Whether to Support Mapping
ENUM	VARCHAR2	Yes
SET	VARCHAR2	Yes
VARCHAR	VARCHAR2	Yes
NUMERIC	NUMBER	Yes
FLOAT	BINARY_FLOAT	Yes
TIMESTAMP	TIMESTAMP WITH TIME ZONE	Yes
DATETIME	TIMESTAMP	Yes
DATE	DATE	Yes
TIME	INVERVAL DAY TO SECOND	Yes
YEAR	VARCHAR2	Yes
BIT	RAW	Yes
CLOB	CLOB	Yes
GEOMETRY	-	No
VARBINARY	BLOB	Yes
BINARY	RAW	Yes
DOUBLE	BINARY_DOUBLE	Yes
DECIMAL	NUMBER	Yes
INT	NUMBER	Yes
TINYINT	NUMBER	Yes
SMALLINT	NUMBER	Yes
MEDIUMINT	NUMBER	Yes
BIGINT	NUMBER	Yes
BLOB	BLOB	Yes
LONGBLOB	BLOB	Yes
MEDIUMBLOB	BLOB	Yes
CHAR	CHAR	Yes
TEXT	CLOB	Yes
JSON	CLOB	Yes

Parent topic: Mapping Data Types

Previous topic: MySQL->GaussDB

Next topic: MySQL->CSS/ES

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.