版本:v2.7
同步数据到异构数据库,字段类型会有变化吗?
Q:同步数据到异构数据库,字段类型会有什么变化?
- 系统会根据数据源和目的地类型做出Schema Mapping(请看下方表格),暂时不支持用户手动修改目的地字段类型。从v2.0版本开始,将会支持用户自定义目的地字段类型。 | 数据源 | 数据源字段类型 | 目的地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 |