说明：本文仅列举在同步过程中不支持的字段类型，其它不在范围的数据源逐步补充。

Oracle作为源

目标 不支持字段
Oracle RAW，LONG_RAW，BFILE，XMLTYPE，STRUCT
Mongo RAW，LONG_RAW，BFILE，XMLTYPE，STRUCT，INTERVAL DAY(2) TO SECOND(6),INTERVAL YEAR(4) TO MONTH
SqlServer 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
PG RAW，LONG_RAW，BFILE，XMLTYPE，STRUCT，INTERVAL DAY(2) TO SECOND(6),INTERVAL YEAR(4) TO MONTH
ES 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
Mongo GEOMETRY,POINT,LINESTRING,POLYGON,MULTIPOINT,MULTILINESTRING,MULTIPOLYGON,GEOMETRYCOLLECTION,DOUBLE UNSIGNED,DOUBLE UNSIGNED,BINARY,VARBINARY,TINYBLOB,BLOB,LONGBLOB
SqlServer 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
PG GEOMETRY,POINT,LINESTRING,POLYGON,MULTIPOINT,MULTILINESTRING,MULTIPOLYGON,GEOMETRYCOLLECTION,DOUBLE UNSIGNED,DOUBLE UNSIGNED,BINARY,VARBINARY,TINYBLOB,BLOB,LONGBLOB
ES 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

SQLServer作为源

注意：受SQL Server本身机制的影响，SQL Server作为源时，如果要同步的表无主键且包含 ntext 、 text 、 image中任一字段类型，当发生更新或者删除操作时，可能会导致更新或删除多条数据(多条数据中，仅前文中字段的值不一致，其余字段值都一致的情况下)

目标 不支持字段
Oracle xml, geometry, geography
Mongo xml, geometry, geography
SqlServer
Mysql xml, geometry, geography
PG xml, geometry, geography
ES 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
Mongo point, line, lseg, box, path, polygon, circle, int4range, int8range, numrange, tsrange, tstzrange, daterange, macaddr8, uuid, xml
SqlServer 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
PG ‘int4range’, ‘int8range’, ‘numrange’, ‘tsrange’, ‘tstzrange’, ‘daterange’
ES 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
Mongo
SqlServer JAVASCRIPT,MIN_KEY,REGULAR_EXPRESSION,MAX_KEY
Mysql JAVASCRIPT,MIN_KEY,REGULAR_EXPRESSION,MAX_KEY
PG JAVASCRIPT,MIN_KEY,REGULAR_EXPRESSION,MAX_KEY
ES 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

更多疑问或加入产品技术交流群：
官网.png
扫码添加 Tapdata 官方小助手

立即免费使用