Here is the list of MySQL datatypes which can be used in place of Oracle datatypes while converting data from Oracle to MySQL. Please note that not all the Oracle datatypes have their equivalent in MySQL. For Example, BFILE, INTDAYTOSECOND, INTYEARTOMONTH, BINFLOAT etc. does not exact equivalent in MySQL. So we should map them to the closest equivalent.
| Oracle Datatype | Equivalent MySQL datatype |
| BFILE | LongBLOB |
| BINDOUBLE | Double |
| BINFLOAT | Integer |
| BLOB | LongBLOB |
| CHAR | Varchar |
| CLOB | LongText |
| DATE | DateTime |
| FLOAT | Double |
| INTDAYTOSECOND | Varchar |
| INTYEARTOMONTH | Varchar |
| LONG | LongText |
| NCHAR | NChar |
| NCLOB | LongText |
| NUMBER | Decimal |
| NUMBERP | Decimal |
| NVARCHAR2 | NVarchar |
| RAW | LongBlob |
| ROWID | Varchar |
| TIMESTAMP | DateTime |
| TIMESTAMPWITHLTZ | DateTime |
| TIMESTAMPWITHTZ | DateTime |
| UROWID | Varchar |
| VARCHAR2 | Varchar |