MySQL Source Data Type | Oracle Target Data Type |
|---|---|
bigint | number(19) |
bigint unsigned | number(20) |
binary(size), 1 <= size <= 255 | raw(size), 1 <= size <= 255 |
bit(precision), 1 <= p <= 64 | raw(size), 1 <= size <= 8 |
blob | blob |
char(size), 1 <= size <= 255 | varchar2(s char), 3 <= s <= 765 |
date | date |
datetime | date |
decimal(p,s), 1 <= p <= 38, 0 <= s <= 29 | number(p,s), 1 <= p <= 38, 0 <= s <= 29 |
decimal(p,s), 39 <= p <= 65, 0 <= s <= 29 | char(s char), 40 <= s <= 67 |
double | binary_double |
float | binary_float |
geomcollection | blob |
geometry | blob |
geometrycollection | blob |
int | number(10) |
int unsigned | number(10) |
json | nclob |
linestring | blob |
longblob | blob |
longtext | nclob |
mediumblob | blob |
mediumint | number(7) |
mediumint unsigned | number(8) |
mediumtext | nclob |
multilinestring | blob |
multipoint | blob |
multipolygon | blob |
numeric(10,0) | number(10) |
point | blob |
polygon | blob |
smallint | number(5) |
smallint unsigned | number(5) |
text | nclob |
time(precision), 0 <= p <= 6 | char(s char), 10 <= s <= 17 |
timestamp(precision), 0 <= p <= 6 | timestamp(precision), 0 <= p <= 6 |
tinyblob | raw |
tinyint | number(3) |
tinyint unsigned | number(3) |
tinytext | nvarchar2 |
varbinary(size), 1 <= size <= 2000 | raw(size), 1 <= size <= 2000 |
varbinary(size), 2001 <= size <= 65535 | long raw |
varchar(size), 1 <= size <= 4000 | varchar2(s char), 3 <= s <= 4000 |
varchar(size), 4001 <= size <= 21844 | clob |
year | number(4) |