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`