Supported data types

Each CDC Replication replication engine supports a variety of data types. When you map source and target columns for replication in Management Console, you should know which data types are compatible.

For a list of column mappings that are supported by the different engines, see Supported column mappings.

CDC Replication Engine for Db2 Database

The following data types are supported:

BIGINT
BINARY
BLOB
BOOLEAN
CHAR
CHARACTER FOR BIT DATA
CLOB
DATE
DBCLOB
DECFLOAT
DECIMAL
DOUBLE
FLOAT
GRAPHIC
INTEGER
LOB
LONG VARCHAR
LONG VARCHAR FOR BIT DATA
LONG VARGRAPHIC
NUMERIC
REAL
SMALLINT
TIME
TIMESTAMP
VARBINARY
VARCHAR
VARCHAR FOR BIT DATA
VARGRAPHIC
XML

CDC Replication Engine for Db2 for i

The following data types are supported:

BIGINT
BLOB
CHAR
CLOB
DATE DMY
DATE EUR
DATE ISO
DATE JUL
DATE MDY
DATE USA
DATE YMD
DBCLOB
DBCS EITHR
DBCS GRAPHIC
DBCS ONLY
DBCS OPEN
DECIMAL
DOUBLE
FLOAT
GRAPHIC
HEX (fixed length only)
INTEGER
REAL
SMALLINT
TIME EUR
TIME HMS
TIME ISO
TIME JIS
TIME USA
TIMESTAMP
VARCHAR
VARGRAPHIC
ZONED NUMERIC

CDC Replication Engine for Db2 for z/OS

The following data types are supported:

BIGINT
BINARY
BLOB
CHAR
CHARACTER
CHARACTER FOR BIT DATA
CLOB
DATE
DBCLOB
DECFLOAT
DECIMAL
DOUBLE
FLOAT
GRAPHIC
INTEGER
LOB
REAL
ROWID
SMALLINT
TIME
TIMESTAMP
TIMESTAMP WITH TIME ZONE
VARBINARY
VARCHAR
VARCHAR FOR BIT DATA
VARGRAPHIC
XML

CDC Replication Engine for Db2 for z/OS Remote Source

The following data types are supported:

BIGINT
BINARY
BLOB
CHAR
CHARACTER
CHARACTER FOR BIT DATA
CLOB
DATE
DBCLOB
DECFLOAT
DECIMAL
DOUBLE
FLOAT
GRAPHIC
INTEGER
LOB
REAL
ROWID
SMALLINT
TIME
TIMESTAMP
TIMESTAMP WITH TIME ZONE
VARBINARY
VARCHAR
VARCHAR FOR BIT DATA
VARGRAPHIC
XML

CDC Replication Engine for FlexRep

The CDC Replication Engine for FlexRep applies data to the target using the functionality and data types available with the JDBC4 specification. The CDC Replication Engine for FlexRep does not support all the data types supported by each driver. If you have a question about a data type not on this list, please contact IBM®.

BIGINT
BINARY
BIT
BLOB
BOOLEAN
CHAR
CLOB
DATE
DECIMAL
DOUBLE
FLOAT
GRAPHIC
HEX (fixed length only)
INTEGER
LONG NVARCHAR
LONG VARBINARY
LONG VARCHAR
NCHAR
NCLOB
NUMERIC
NVARCHAR
REAL
SMALLINT
SQLXML
TIME
TIMESTAMP
TINYINT
VARBINARY
VARCHAR

CDC Replication Engine for Informix

The following data types are supported:

BIGINT
BIGSERIAL
BLOB
BOOLEAN
BYTE
CHAR
CHARACTER
CHARACTER VARYING
CLOB
DATE
DATETIME
DATETIME HOUR TO SECOND
DATETIME YEAR TO FRACTION(5)
DECIMAL1
FLOAT
INT8
INTEGER
LVARCHAR
MONEY
NCHAR
NUMERIC
NVARCHAR
REAL
SERIAL
SERIAL8
SMALLFLOAT
SMALLINT
TEXT
VARCHAR
  1. Only fixed-point decimal is supported.

CDC Replication Engine for Kafka

The following data types are supported:

BYTES
DATA
DECIMAL
DOUBLE
DURATION
INT
LONG
STRING
TIMESTAMP-MICROS
TIME-MILLIS

CDC Replication Engine for MariaDB Source

The following data types are supported:

TINYINT
SMALLINT
INTEGER
BIGINT
DECIMAL
FLOAT
DOUBLE
CHAR
VARCHAR
BOOLEAN
TINYTEXT
TEXT
MEDIUMTEXT
LONGTEXT
DATE
TIME
DATETIME
TIMESTAMP
BINARY
VARBINARY
TINYBLOB
BLOB
MEDIUMBLOB
LONGBLOB

CDC Replication Engine for Microsoft SQL Server

The following data types are supported:

BIGINT
BINARY
BIT
CHAR
DATE
DATETIME
DATETIME2
DATETIMEOFFSET
DECIMAL
FLOAT
GEOGRAPHY
GEOMETRY
IMAGE
INTEGER
MONEY
NCHAR
NTEXT
NUMERIC
NVARCHAR
REAL
ROWVERSION
SMALLDATETIME
SMALLMONEY
SQL_VARIANT
TIME
TINYINT
UNIQUEIDENTIFIER
VARBINARY
VARBINARY(MAX)

CDC Replication Engine for MySQL Source

The following data types are supported:

TINYINT
SMALLINT
INTEGER
BIGINT
DECIMAL
FLOAT
DOUBLE
CHAR
VARCHAR
BOOLEAN
TINYTEXT
TEXT
MEDIUMTEXT
LONGTEXT
DATE
TIME
DATETIME
TIMESTAMP
BINARY
VARBINARY
TINYBLOB
BLOB
MEDIUMBLOB
LONGBLOB

CDC Replication Engine for Netezza Technology

The following data types are supported:

BIGINT
BOOLEAN
BOOL
BYTEINT
CHAR
CHARACTER
CHARACTER VARYING
DATE
DECIMAL
DOUBLE PRECISION
FLOAT
FLOAT(p)
INTEGER
NCHAR
NUMERIC
NUMERIC(p,s)
NUMERIC(p)
NVARCHAR
REAL
SMALLINT
TIME
TIMESTAMP
VARBINARY
VARCHAR

CDC Replication Engine for Oracle databases

The following data types are supported:

BIGINT
BINARY_DOUBLE
BINARY_FLOAT
BLOB
CHAR
CLOB
DATE
FLOAT
INTEGER
INTERVAL DAY TO SECOND
INTERVAL DAY TO MONTH
LOB
LONG RAW
LONG VARCHAR
NCHAR
NCLOB
NUMERIC
NVARCHAR2
RAW
REAL
ROWID
TIMESTAMP
TIMESTAMP WITH TIME ZONE
TIMEZONE
VARCHAR2
XML
XMLTYPE

CDC Replication Engine for Oracle (Trigger edition)

The following data types are supported:

BIGINT
BINARY_DOUBLE
BINARY_FLOAT
BLOB
CHAR
CLOB
DATE
FLOAT
INTEGER
INTERVAL DAY TO SECOND
INTERVAL DAY TO MONTH
LOB
LONG RAW
LONG VARCHAR
NCHAR
NCLOB
NUMERIC
NVARCHAR2
RAW
REAL
ROWID
TIMESTAMP
TIMESTAMP WITH TIME ZONE
TIMEZONE
VARCHAR2
XML
XMLTYPE

CDC Replication Engine for Oracle XStream

The following data types are supported:

BIGINT
BINARY_DOUBLE
BINARY_FLOAT
BLOB
CHAR
CLOB
DATE
FLOAT
INTEGER
INTERVAL DAY TO SECOND
INTERVAL DAY TO MONTH
LOB
LONG RAW
LONG VARCHAR
NCHAR
NCLOB
NUMERIC
NVARCHAR2
RAW
REAL
TIMESTAMP
TIMESTAMP WITH TIME ZONE
VARCHAR2
XMLTYPE

CDC Replication Engine for Teradata

The following data types are supported:

BYTE
BYTEINT
CHAR
DATE
DECIMAL
DOUBLE
FLOAT
GRAPHIC
IMAGE
INTEGER
LONG VARCHAR
NUMBER
NUMERIC
REAL
SMALLINT
TIME
TIMESTAMP
TIMESTAMP WITH TIME ZONE
VARBYTE
VARCHAR
VARGRAPHIC