Oracle to MySQL mapping
AutoSync maps Oracle column types to the following MySQL column types:
Oracle column type | MySQL column type |
---|---|
char |
CHAR |
varchar2 |
VARCHAR |
nchar |
CHAR |
nvarchar2 |
VARCHAR |
number |
DECIMAL |
number_without_prec_scale |
DOUBLE |
float |
DOUBLE |
binary_float |
DOUBLE |
binary_double |
DOUBLE |
long |
VARCHAR |
long raw |
BLOB |
raw |
BLOB |
date |
DATE |
timestamp |
DATETIME |
timestamp with time zone |
DATETIME |
timestamp with local time zone |
DATETIME |
interval year to month |
VARCHAR |
interval day to second |
VARCHAR |
sl_timestamp |
DATETIME |
blob |
BLOB |
clob |
VARCHAR |
nclob |
VARCHAR |
bfile |
BLOB |
rowid |
VARCHAR |
urowid |
VARCHAR |
anydata |
VARCHAR |
xmltype |
VARCHAR |