MySQL Source | Flat File Target | Microsoft SQL Server Target | MySQL Target | Oracle Target |
|---|---|---|---|---|
Bigint | Int | Bigint | Bigint | Number |
Binary | Not supported. | Binary | Binary | Not supported. |
Bit | Not supported. | Not supported. | Not supported. | Not supported. |
Blob | Not supported. | Image | Longblob | Not supported. |
Bool | Int | Int | Int | Number |
Boolean | Int | Int | Int | Number |
Char | Nstring | Char (Nchar if MySQL code page is UTF-8) | Char | Char (Nchar if MySQL code page is UTF-8) |
Date | Datetime | Not supported. | Date | Date |
Datetime | Datetime | Datetime | Datetime | Date |
Dec | Number | Decimal | Decimal | Number(p,s) |
Decimal | Number | Decimal | Decimal | Number(p,s) |
Double Precision | Number | Float | Double(p) | Number |
Double(p,s) | Number | Decimal | Double(p,s) | Number(p,s) |
Double[(p)] | Number | Float | Double(p) | Number |
Enum | Nstring | Char (Nchar if MySQL code page is UTF-8) | Char | Char (Nchar if MySQL code page is UTF-8) |
Float(p,s) | Number | Decimal | Double(p,s) | Number |
Float[(p)] | Number | Real, Float | Float(p) | Number |
Int | Int | Int | Int | Number |
Integer | Int | Int | Int | Number |
Longblob | Not supported. | Image | Longblob | Not supported. |
Longtext | Nstring | Text (Ntext if MySQL code page is UTF-8) | Text | Clob (Nclob if MySQL code page is UTF-8) |
Mediumblob | Not supported. | Image | Longblob | Not supported. |
Mediumint | Int | Int | Int | Number |
Mediumtext | Nstring | Text (Ntext if MySQL code page is UTF-8) | Text | Clob (Nclob if MySQL code page is UTF-8) |
Serial | Int | Bigint | Bigint | Number |
Set | Nstring | Char (Nchar if MySQL code page is UTF-8) | Char | Char (Nchar if MySQL code page is UTF-8) |
Smallint | Int | Int | Int | Number |
Text | Nstring | Text (Ntext if MySQL code page is UTF-8) | Text | Clob (Nclob if MySQL code page is UTF-8) |
Time | Datetime | Not supported. | Time | Date* |
Timestamp | Datetime | Datetime | Datetime | Date |
Tinyblob | Not supported. | Binary | Binary | Not supported. |
Tinyint | Int | Int | Int | Number |
Tinytext | Nstring | Varchar (Nvarchar if MySQL code page is UTF-8) | Varchar | Varchar2 (Nvarchar if MySQL code page is UTF-8) |
Varbinary | Not supported. | Varbinary | Varbinary | Not supported. |
Varchar | Nstring | Varchar (Nvarchar if MySQL code page is UTF-8) | Varchar | Varchar2 (Nvarchar if MySQL code page is UTF-8) |
Year | Not supported. | Not supported. | Not supported. | Not supported. |
*The data replication task converts MySQL time data to Oracle date data because Oracle does not contain a time datatype. Oracle date data contains the date and time. The task writes the current date and the time specified in the MySQL source to the Oracle date field. | ||||