...
Source | Target | |||
---|---|---|---|---|
Oracle | Oracle 9.2 | Oracle 10+ | MS SQL Server | MySQL |
NUMBER | NUMBER | NUMBER | FLOAT or BIGINT(when scale==0) | FLOAT or BIGINT(when scale==0) |
FLOAT | FLOAT | FLOAT | FLOAT | FLOAT |
VARCHAR2 | VARCHAR2 | VARCHAR2 | VARCHAR/NVARCHAR | VARCHAR |
VARCHAR | VARCHAR | VARCHAR | VARCHAR/NVARCHAR | VARCHAR |
CHAR | CHAR | CHAR | CHAR/NVARCHAR | CHAR |
NVARCHAR2 | NVARCHAR2 | NVARCHAR2 | VARCHAR/NVARCHAR | VARCHAR |
NCHAR2 | NCHAR2 | NCHAR2 | VARCHAR/NVARCHAR | VARCHAR |
NCHAR | NCHAR | NCHAR | VARCHAR/NVARCHAR | VARCHAR |
DATE | DATE | DATE | DATETIME | DATETIME |
RAW | RAW | RAW | VARBINARY | VARBINARY |
LONG | x | LONG | TEXT | TEXT |
LONG RAW | x | LONG RAW | BLOB | BLOB |
BFILE | BFILE | BFILE | x | x |
CLOB | CLOB | CLOB | x | x |
BLOB | BLOB | BLOB | x | x |
LOB | LOB | LOB | x | x |
NCLOB | NCLOB | NCLOB | x | x |
INTERVAL | INTERVAL | INTERVAL | x | x |
TIMESTAMP | TIMESTAMP | TIMESTAMP | x | x |
...