One, the transition from MySQL to Oracle data types:
Number |
Mysql |
Tooracle |
Oracle |
1 |
GEOMETRY |
Blob |
Blob |
2 |
GeometryCollection |
Blob |
Blob |
3 |
Multilinestring |
Blob |
Blob |
4 |
LINESTRING |
Blob |
Blob |
5 |
MULTIPOINT |
Blob |
Blob |
6 |
Multipolygon |
Blob |
Blob |
7 |
Point |
Blob |
Blob |
8 |
POLYGON |
Blob |
Blob |
9 |
DECIMAL |
INTEGER |
Number |
10 |
DECIMAL (10) |
INTEGER |
Number |
11 |
Blob |
VARCHAR2 (2000) |
Blob |
12 |
BLOB (10) |
VARCHAR2 (2000) |
Blob |
13 |
Longblob |
VARCHAR2 (2000) |
Blob |
14 |
Mediumblob |
VARCHAR2 (2000) |
Blob |
15 |
Tinyblob |
VARCHAR2 (2000) |
Blob |
16 |
BINARY (10) |
Blob |
RAW |
17 |
VARBINARY (10) |
VARCHAR2 (2000) |
RAW |
18 |
Year |
DATE |
Number (3,0) |
19 |
DOUBLE |
Number |
Binary_double( number also can) |
20 |
FLOAT |
Number |
Binary_float( number also can) |
21st |
CHAR (2) |
VARCHAR2 (2) |
CHAR |
22 |
NVARCHAR (10) |
VARCHAR2 (10) |
NVARCHAR |
23 |
TEXT ( created after the table becomes tinytext) |
VARCHAR2 (85) |
Clob |
24 |
REAL ( becomes Double after generating the table ) |
Number |
Number |
25 |
BIT |
VARCHAR2 (2000) |
RAW |
26 |
ENUM (' test1 ', ' test2 ') |
VARCHAR2 (5) |
VARCHAR2 |
27 |
SET (' test1 ', ' test2 ') |
VARCHAR2 (11) |
VARCHAR2 |
28 |
Int |
INTEGER |
Number |
29 |
TIMESTAMP |
DATE |
TIMESTAMP |
30 |
BIGINT |
INTEGER |
Number |
31 |
INT (8) |
INTEGER |
Number |
32 |
Mediumini (10) |
INTEGER |
Number |
33 |
SMALLINT (2) |
INTEGER |
Number |
34 |
TINYINT |
INTEGER |
Number |
35 |
Tinytext |
VARCHAR2 (85) |
Clob |
36 |
VARCHAR |
VARCHAR |
VARCHAR |
38 |
DATE |
DATE |
DATE |
39 |
Datetime |
Datetime |
Datetime |
40 |
Time |
DATE |
VARCHAR |
41 |
Longtext |
Clob |
Clob |
42 |
Mediumtext |
Clob |
Clob |
II. Transformation of Oracle-to-MySQL data types
Number |
Oracle |
to MySQL |
Mysql |
1 |
Binary_double |
Tinytext |
DOUBLE |
2 |
Binary_float |
Tinytext |
FLOAT |
3 |
Blob |
Longblob |
Blob |
4 |
CHAR |
VARCHAR (2) |
CHAR |
5 |
DATE |
UNKNOWN |
DATE |
6 |
INTERVAL Day Tosecond |
Tinytext |
Tinytext |
7 |
INTERVAL year to MONTH |
Tinytext |
Tinytext |
8 |
Number |
DOUBLE |
Number |
9 |
NVARCHAR2 |
VARCHAR (20) |
NVARCHAR2 |
10 |
RAW |
VARCHAR (20) |
|
11 |
TIMESTAMP |
UNKNOWN |
Datetime |
12 |
TIMESTAMP (6) with LOCAL time ZONE |
Tinytext |
Tinytext |
13 |
TIMESTAMP (6) with time ZONE |
Tinytext |
Tinytext |
14 |
Clob |
Mediumtext |
Mediumtext |
15 |
LONG |
Tinytext |
Tinytext |
16 |
NCLOB |
Mediumtext |
Mediumtext |
17 |
VARCHAR2 |
VARCHAR2 |
VARCHAR2 |
Data type conversion reference between heterogeneous relational databases (MySQL and Oracle)