Updated on 2024-04-11 GMT+08:00

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