### Q：同步数据到异构数据库，字段类型会有什么变化？ * 系统会根据数据源和目的地类型做出Schema Mapping（请看下方表格），暂时不支持用户手动修改目的地字段类型。从v2.0版本开始，将会支持用户自定义目的地字段类型。 | 数据源<p style="width:50px" ></p> | 数据源字段类型<p style="width:60px"></p> | 目的地ORACLE时字段类型变化 | 目的地REDSHIFT时字段类型变化 | 目的地GreenPlum时字段类型变化 | 目的地RDS/TIDB时字段类型变化 | | --- | --- | --- | --- | --- | --- | | MYSQL| TINYINT | INTEGER | INTEGER | INTEGER | INTEGER | | MYSQL| SMALLINT | INTEGER | INTEGER | INTEGER | INTEGER | | MYSQL| INTEGER | NTEGER | NTEGER | NTEGER | NTEGER | | MYSQL| BIGINT | NUMBER(38) | BIGINT | BIGINT | BIGINT | | MYSQL| REAL | BINARY_FLOAT | DECIMAL(p,s) | FLOAT | FLOAT | | MYSQL| FLOAT | BINARY_FLOAT | DECIMAL(p,s) | FLOAT | FLOAT | | MYSQL| DOUBLE | BINARY_DOUBLE | DECIMAL(p,s) | FLOAT | DOUBLE | | MYSQL| DECIMAL | BINARY_DOUBLE | DECIMAL(p,s) | FLOAT | DOUBLE | | MYSQL| NUMERIC | BINARY_DOUBLE | DECIMAL(p,s) | FLOAT | DOUBLE | | MYSQL| BIT | BLOB | VARCHAR(65535)(暂时是Bytes 地址) | TEXT(暂时是Bytes 地址) | BIGINT(暂时是Bytes 地址) | | MYSQL| BIT | NUMBER(1) | BOOLEAN | BOOLEAN | BOOLEAN | | MYSQL| BOOLEAN | NUMBER(1) | BOOLEAN | BOOLEAN | BOOLEAN | | MYSQL| DATE | DATE | DATE | DATE | DATE | | MYSQL| TIMESTAMP |DATE | DATE | DATE | DATE | | MYSQL| BLOB | BLOB | VARCHAR(65535) | TEXT | TEXT | | MYSQL| BINARY | BLOB | VARCHAR(65535) | TEXT | TEXT | | MYSQL| VARBINARY | BLOB | VARCHAR(65535) |TEXT | TEXT | | MYSQL| LONGVARBINARY | BLOB | VARCHAR(65535) | TEXT | | MYSQL| Anothers | VARCHAR2 / NCLOB | VARCHAR(n) | TEXT | TEXT | | ORACLE | BINARY_FLOAT | BINARY_FLOAT | DECIMAL(p,s) | FLOAT | FLOAT | | ORACLE | BINARY_DOUBLE | BINARY_DOUBLE | DECIMAL(p,s) | FLOAT | DOUBLE | | ORACLE | CLOB | BLOB | VARCHAR(65535)(暂时是Bytes 地址) | TEXT(暂时是Bytes 地址) | TEXT(暂时是Bytes 地址) | | ORACLE | NCLOB | BLOB | VARCHAR(65535)(暂时是Bytes 地址) | TEXT(暂时是Bytes 地址) | TEXT(暂时是Bytes 地址) | | ORACLE | BLOB | BLOB | VARCHAR(65535)(暂时是Bytes 地址) | TEXT(暂时是Bytes 地址) | TEXT(暂时是Bytes 地址) | | ORACLE | BFILE | BLOB |VARCHAR(65535)(暂时是Bytes 地址) | TEXT(暂时是Bytes 地址) | TEXT(暂时是Bytes 地址) | | ORACLE | CHAR | VARCHAR2 / NCLOB | VARCHAR(n) | TEXT | TEXT | | ORACLE | VARCHAR | VARCHAR2 / NCLOB | VARCHAR(n) | TEXT | TEXT | | ORACLE | VARCHAR2 | VARCHAR2 / NCLOB | VARCHAR(n) | TEXT | TEXT | | ORACLE | SYS.XMLTYPE | VARCHAR2 / NCLOB | VARCHAR(n) | TEXT | TEXT | | ORACLE | SYS.XDBURITYPE | VARCHAR2 / NCLOB | VARCHAR(n) | TEXT | TEXT | | ORACLE | SYS.URITYPE | VARCHAR2 / NCLOB | VARCHAR(n) | TEXT | TEXT | | ORACLE | SYS.DBURITYPE | VARCHAR2 / NCLOB | VARCHAR(n) | TEXT | TEXT | | ORACLE | SYS.HTTPURITYPE | VARCHAR2 / NCLOB | VARCHAR(n) |TEXT | TEXT | | ORACLE | NVARCHAR2 | VARCHAR2 / NCLOB | VARCHAR(n) |TEXT | TEXT | | ORACLE | DATE | DATE | DATE | DATE | DATE | | ORACLE | TIMESTAMP | DATE | DATE | DATE | DATE | | ORACLE | TIMESTAMP WITH TIME ZONE | DATE | DATE | DATE | DATE | | ORACLE | TIMESTAMP WITH LOCAL TIME ZONE | DATE | DATE | DATE | DATE | | ORACLE | INTERVALYM | VARCHAR2 | VARCHAR(n) | TEXT | TEXT | | ORACLE | INTERVALDS | VARCHAR2 | VARCHAR(n) | TEXT | TEXT | | ORACLE | NUMBER | NUMBER | DECIMAL(p,s) | DECIMAL(p,s) | DECIMAL(p,s) | | SQLSERVER | BINARY | BLOB | VARCHAR(65535)(暂时是Bytes 地址) | TEXT(暂时是Bytes 地址) | TEXT(暂时是Bytes 地址) | | SQLSERVER | VARBINARY | BLOB | VARCHAR(65535)(暂时是Bytes 地址) | TEXT(暂时是Bytes 地址) | TEXT(暂时是Bytes 地址) | | SQLSERVER | IMAGE | BLOB | VARCHAR(65535)(暂时是Bytes 地址) | TEXT(暂时是Bytes 地址) | TEXT(暂时是Bytes 地址) | | SQLSERVER | CHAR |VARCHAR2 / NCLOB | VARCHAR(n) | TEXT | TEXT | | SQLSERVER | VARCHAR |VARCHAR2 / NCLOB | VARCHAR(n) | TEXT | TEXT | | SQLSERVER | TEXT | VARCHAR2 / NCLOB | VARCHAR(n) | TEXT | TEXT | | SQLSERVER | NCHAR | VARCHAR2 / NCLOB | VARCHAR(n) | TEXT | TEXT | | SQLSERVER | NTEXT | VARCHAR2 / NCLOB | VARCHAR(n) | TEXT | TEXT | | SQLSERVER | INT | INTEGER | INTEGER | INTEGER | INTEGER | | SQLSERVER | BIGINT | NUMBER(38) | BIGINT | BIGINT | BIGINT | | SQLSERVER | SMALLINT | INTEGER | INTEGER | INTEGER | INTEGER | | SQLSERVER | TINYINT | INTEGER | INTEGER | INTEGER | INTEGER | | SQLSERVER | BIT | NUMBER(1) | BOOLEAN | BOOLEAN | BOOLEAN | | SQLSERVER | NUMERIC | NUMBER | DECIMAL(p,s) | DECIMAL(p,s) | DECIMAL(p,s) | | SQLSERVER | MONEY | NUMBER | DECIMAL(p,s) | DECIMAL(p,s) | DECIMAL(p,s) | | SQLSERVER | SMALLMONEY | NUMBER | DECIMAL(p,s) | DECIMAL(p,s) | DECIMAL(p,s) | | SQLSERVER | FLOAT | BINARY_DOUBLE | DECIMAL(p,s) | FLOAT | DOUBLE | | SQLSERVER | REAL | BINARY_FLOAT | DECIMAL(p,s) | FLOAT | FLOAT | | SQLSERVER | TIMESTAMP | INTEGER | INTEGER | INTEGER | INTEGER |