The DBMS-specific sections on the following pages describe the Connect CDC datatype support for the following DBMSs:
For each DBMS, the Connect CDC-supported datatypes are displayed in tables. Unless otherwise specified, support is for both sending and receiving columns, Replication and Copy, and all supported DBMSs.
The table below specifies the datatypes that Connect CDC supports.
|
DB2 |
MSS / AZ |
MySQL |
Oracle |
PostgreSQL |
|
|---|---|---|---|---|---|
|
IBM i |
UDB |
||||
|
Bigint |
Bigint |
Bigint |
Bigint |
|
Bigint |
|
|
|
Binary |
Binary |
|
|
|
|
|
Bit |
Bit |
|
|
|
Blob |
|
|
Blob |
Blob |
|
|
|
|
|
|
|
Boolean |
|
|
|
|
|
|
Bytea |
|
|
|
|
|
|
|
|
Char |
Char |
Char |
Char |
Char |
Char |
|
Char ForBit |
Char ForBit |
|
|
|
|
|
Clob |
|
|
|
Clob |
|
|
Date |
Date |
Date |
Date |
Date |
Date |
|
|
|
Datetime |
Datetime |
|
|
|
|
|
Datetime2(p) |
|
|
|
|
|
|
Datetimeoffset(p) |
|
|
|
|
Dbclob |
|
|
|
|
|
|
Decimal |
Decimal |
Decimal |
Decimal |
Decimal |
Decimal |
|
Double |
Double |
Double Precision |
Double |
DoublePrecision |
DoublePrecision |
|
Float |
Float |
Float |
Float |
Float |
|
|
|
|
GEOGRAPHY |
|
|
|
|
|
|
GEOMETRY |
|
|
|
|
Graphic |
Graphic |
|
|
|
|
|
|
|
Image |
|
|
|
|
Integer |
Integer |
Integer |
|
Integer |
Integer |
|
|
|
|
Int |
|
|
|
|
|
|
|
Long |
|
|
|
|
|
Longblob |
|
|
|
|
|
|
|
Longraw |
|
|
|
|
|
Longtext |
|
|
|
|
|
|
Mediumblob |
|
|
|
|
|
|
Mediumint |
|
|
|
|
|
|
Mediumtext |
|
|
|
|
|
Money |
|
|
Money |
|
|
|
Nchar |
Nchar |
Nchar |
|
|
|
|
|
|
Nclob |
|
|
|
|
Ntext |
|
|
|
|
|
|
|
|
Number |
|
|
Numeric |
Numeric |
Numeric |
Numeric |
Numeric |
Numeric |
|
|
|
Nvarchar |
Nvarchar |
|
|
|
|
|
|
|
Nvarchar2 |
|
|
|
|
Nvarchar(max) |
|
|
|
|
|
|
|
|
Raw |
|
|
Real |
Real |
Real |
Real |
Real |
Real |
|
|
|
|
|
SDO_GEOMETRY |
|
|
|
|
|
|
ST_GEOMETRY |
|
|
|
|
|
Serial |
|
|
|
|
|
Smalldatetime |
|
|
|
|
Smallint |
Smallint |
Smallint |
Smallint |
Smallint |
Smallint |
|
|
|
Smallmoney |
|
|
|
|
|
|
Text |
Text |
|
Text |
|
Time |
Time |
Time |
Time |
|
Time |
|
|
|
Time(p) |
|
|
|
|
Timestamp |
Timestamp |
|
|
Timestamp |
Timestamp |
|
|
|
|
Timestamp(p) |
Timestamp(p) |
|
|
|
|
|
Tinyblob |
|
|
|
|
|
Tinyint |
Tinyint |
|
|
|
|
|
|
Tinytext |
|
|
|
|
|
UniqueIdentifier |
|
|
|
|
|
|
Varbinary |
|
|
|
|
|
|
Varbinary(max) |
Varbinary(max) |
|
|
|
Varchar |
Varchar |
Varchar |
Varchar |
Varchar |
Varchar |
|
Varchar For Bit |
Varchar For Bit |
|
|
|
|
|
|
|
|
|
Varchar2 |
|
|
|
|
Varchar(max) |
|
|
|
|
Vargraphic |
Vargraphic |
|
|
|
|
|
|
|
XML |
|
|
|
|
|
|
|
|
XMLTYPE |
|
|
|
|
|
Year |
|
|