数据类型支持说明
提示
本文仅列举在同步过程中不支持的字段类型，不在范围的数据源逐步补充。
Oracle 作为源
| 目标 | 不支持字段 |
|---|---|
| Oracle | RAW，LONG_RAW，BFILE，XMLTYPE，STRUCT |
| MongoDB | RAW，LONG_RAW，BFILE，XMLTYPE，STRUCT，INTERVAL DAY(2) TO SECOND(6),INTERVAL YEAR(4) TO MONTH |
| SQL Server | RAW，LONG_RAW，BFILE，XMLTYPE，STRUCT，INTERVAL DAY(2) TO SECOND(6),INTERVAL YEAR(4) TO MONTH |
| MySQL | RAW，LONG_RAW，BFILE，XMLTYPE，STRUCT，INTERVAL DAY(2) TO SECOND(6),INTERVAL YEAR(4) TO MONTH |
| PostgreSQL | RAW，LONG_RAW，BFILE，XMLTYPE，STRUCT，INTERVAL DAY(2) TO SECOND(6),INTERVAL YEAR(4) TO MONTH |
| Elastic Search | RAW，LONG_RAW，BFILE，XMLTYPE，STRUCT，INTERVAL DAY(2) TO SECOND(6),INTERVAL YEAR(4) TO MONTH |
| Kafka | RAW，LONG_RAW，BFILE，XMLTYPE，STRUCT，INTERVAL DAY(2) TO SECOND(6),INTERVAL YEAR(4) TO MONTH |
| ClickHouse | RAW，LONG_RAW，BFILE，XMLTYPE，STRUCT，INTERVAL DAY(2) TO SECOND(6),INTERVAL YEAR(4) TO MONTH,BLOB |
MySQL 作为源
| 目标 | 不支持字段 |
|---|---|
| Oracle | GEOMETRY,POINT,LINESTRING,POLYGON,MULTIPOINT,MULTILINESTRING,MULTIPOLYGON,GEOMETRYCOLLECTION,DOUBLE UNSIGNED,DOUBLE UNSIGNED,BINARY,VARBINARY,TINYBLOB,BLOB,LONGBLOB |
| MongoDB | GEOMETRY,POINT,LINESTRING,POLYGON,MULTIPOINT,MULTILINESTRING,MULTIPOLYGON,GEOMETRYCOLLECTION,DOUBLE UNSIGNED,DOUBLE UNSIGNED,BINARY,VARBINARY,TINYBLOB,BLOB,LONGBLOB |
| SQL Server | GEOMETRY,POINT,LINESTRING,POLYGON,MULTIPOINT,MULTILINESTRING,MULTIPOLYGON,GEOMETRYCOLLECTION,DOUBLE UNSIGNED,DOUBLE UNSIGNED,BINARY,VARBINARY,TINYBLOB,BLOB,LONGBLOB |
| MySQL | GEOMETRY,POINT,LINESTRING,POLYGON,MULTIPOINT,MULTILINESTRING,MULTIPOLYGON,GEOMETRYCOLLECTION |
| PostgreSQL | GEOMETRY,POINT,LINESTRING,POLYGON,MULTIPOINT,MULTILINESTRING,MULTIPOLYGON,GEOMETRYCOLLECTION,DOUBLE UNSIGNED,DOUBLE UNSIGNED,BINARY,VARBINARY,TINYBLOB,BLOB,LONGBLOB |
| Elastic Search | GEOMETRY,POINT,LINESTRING,POLYGON,MULTIPOINT,MULTILINESTRING,MULTIPOLYGON,GEOMETRYCOLLECTION,DOUBLE UNSIGNED,DOUBLE UNSIGNED,BINARY,VARBINARY,TINYBLOB,BLOB,LONGBLOB |
| Kafka | GEOMETRY,POINT,LINESTRING,POLYGON,MULTIPOINT,MULTILINESTRING,MULTIPOLYGON,GEOMETRYCOLLECTION,DOUBLE UNSIGNED,DOUBLE UNSIGNED,BINARY,VARBINARY,TINYBLOB,BLOB,LONGBLOB |
| ClickHouse | GEOMETRY,POINT,LINESTRING,POLYGON,MULTIPOINT,MULTILINESTRING,MULTIPOLYGON,GEOMETRYCOLLECTION,DOUBLE UNSIGNED,BINARY,VARBINARY,TINYBLOB,BLOB,LONGBLOB |
SQL Server 作为源
提示
受SQL Server本身机制的影响，SQL Server作为源时，如果要同步的表无主键且包含 ntext 、 text 、 image中任一字段类型，当发生更新或者删除操作时，可能会导致更新或删除多条数据（多条数据中，仅前文中字段的值不一致，其余字段值都一致的情况下）。
| 目标 | 不支持字段 |
|---|---|
| Oracle | xml, geometry, geography |
| MongoDB | xml, geometry, geography |
| SQL Server | |
| MySQL | xml, geometry, geography |
| PostgreSQL | xml, geometry, geography |
| Elastic Search | xml, geometry, geography |
| Kafka | xml, geometry, geography |
| ClickHouse | xml, geometry, geography,binary,varbinary,image |
PG作为源
| 目标 | 不支持字段 |
|---|---|
| Oracle | point, line, lseg, box, path, polygon, circle, int4range, int8range, numrange, tsrange, tstzrange, daterange, macaddr8, uuid, xml |
| MongoDB | point, line, lseg, box, path, polygon, circle, int4range, int8range, numrange, tsrange, tstzrange, daterange, macaddr8, uuid, xml |
| SQL Server | point, line, lseg, box, path, polygon, circle, int4range, int8range, numrange, tsrange, tstzrange, daterange, macaddr8, uuid, xml |
| MySQL | point, line, lseg, box, path, polygon, circle, int4range, int8range, numrange, tsrange, tstzrange, daterange, macaddr8, uuid, xml |
| PostgreSQL | 'int4range', 'int8range', 'numrange', 'tsrange', 'tstzrange', 'daterange' |
| Elastic Search | point, line, lseg, box, path, polygon, circle, int4range, int8range, numrange, tsrange, tstzrange, daterange, macaddr8, uuid, xml |
| Kafka | point, line, lseg, box, path, polygon, circle, int4range, int8range, numrange, tsrange, tstzrange, daterange, macaddr8, uuid, xml |
| ClickHouse | point, line, lseg, box, path, polygon, circle, int4range, int8range, numrange, tsrange, tstzrange, daterange, macaddr8, uuid, xml, bytea |
MongoDB作为源
| 目标 | 不支持字段 |
|---|---|
| Oracle | JAVASCRIPT,MIN_KEY,REGULAR_EXPRESSION,MAX_KEY |
| MongoDB | |
| SQL Server | JAVASCRIPT,MIN_KEY,REGULAR_EXPRESSION,MAX_KEY |
| MySQL | JAVASCRIPT,MIN_KEY,REGULAR_EXPRESSION,MAX_KEY |
| PostgreSQL | JAVASCRIPT,MIN_KEY,REGULAR_EXPRESSION,MAX_KEY |
| Elastic Search | JAVASCRIPT,MIN_KEY,REGULAR_EXPRESSION,MAX_KEY |
| Kafka | JAVASCRIPT,MIN_KEY,REGULAR_EXPRESSION,MAX_KEY |
| ClickHouse | JAVASCRIPT,MIN_KEY,REGULAR_EXPRESSION,MAX_KEY,BINARY,NULL |