MySQL datatype support - connect_cdc_mimix_share - 5.8

Connect CDC System Reference Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
5.8
Language
English
Product name
Connect CDC
Title
Connect CDC System Reference Guide
Copyright
2024
First publish date
2003
ft:lastEdition
2024-02-12
ft:lastPublication
2024-02-12T15:11:59.486869

The following tables show the MySQL (as target-only) datatype support.

MySQL Target-only Datatype

Supported Sources

BIGINT

(8 bytes)

DB2 (includes IBM i and UDB)

  • BIGINT

  • DECIMAL*

  • FLOAT*

  • INTEGER

  • NUMERIC*

  • REAL*

  • SMALLINT

 

Informix

  • DECIMAL

  • DOUBLE

  • FLOAT

  • INTEGER

  • MONEY

  • NUMERIC

  • REAL

  • SERIAL

  • SMALLFLOAT

  • SMALLINT

 

MS SQL Server

  • BIGINT

  • BIT

  • DECIMAL*

  • DOUBLE PRECISION*

  • FLOAT*

  • INTEGER

  • MONEY*

  • NUMERIC*

  • REAL*

  • SMALLINT

  • SMALLMONEY*

  • TINYINT

BIGINT

(8 bytes)

Oracle

  • DECIMAL*

  • DOUBLE PRECISION*

  • FLOAT*

  • INTEGER

  • NUMBER*

  • NUMERIC*

  • REAL*

  • SMALLINT

 

Sybase

  • BIT

  • DECIMAL*

  • DOUBLE PRECISION*

  • FLOAT*

  • INTEGER

  • MONEY*

  • NUMERIC*

  • REAL*

  • SMALLMONEY*

  • SMALLINT

  • TINYINT

*These mappings are allowed with a warning in the Director; even though values for these data types may cause an overflow or may be incompatible when applying to the target, resulting in an error. When an incorrect value is encountered the behavior depends on the SQL_MODE setting currently in effect for the Applier’s session.

MySQL Target-only Datatype

Supported Sources

BINARY (m)

(M = number of bytes, max 255)

DB2 (includes IBM i and UDB)

  • CHAR FOR BIT

  • BLOB (IBM i) *

 

MS SQL Server

  • BINARY*

  • VARBINARY(MAX)*

 

Sybase

  • BINARY*

  • VARBINARY*

 

MySQL Target-only Datatype

Supported Sources

BIT (m)

M = number of bits, max 64

DB2 (includes IBM i and UDB)

  • BIGINT*

  • DECIMAL*

  • DOUBLE*

  • FLOAT*

  • INTEGER*

  • NUMERIC*

  • REAL*

  • SMALLINT*

 

Informix

  • DECIMAL*

  • DOUBLE PRECISION*

  • FLOAT*

  • INTEGER*

  • MONEY*

  • NUMERIC*

  • REAL*

  • SERIAL*

  • SMALLFLOAT*

  • SMALLINT

 

MS SQL Server

  • BIGINT*

  • BIT

  • DECIMAL*

  • DOUBLE PRECISION*

  • FLOAT*

  • INTEGER*

  • MONEY*

  • NUMERIC*

  • REAL*

  • SMALLINT*

  • SMALLMONEY*

  • TINYINT

BIT (m)

M = number of bits, max 64.

 

Oracle

  • DECIMAL*

  • DOUBLE PRECISION*

  • FLOAT*

  • INTEGER*

  • NUMBER*

  • NUMERIC*

  • REAL*

  • SMALLINT.

 

Sybase

  • BIT

  • DECIMAL*

  • DOUBLE PRECISION*

  • FLOAT*

  • INTEGER*

  • MONEY*

  • NUMERIC*

  • REAL*

  • SMALL MONEY*

  • SMALLINT*

  • TINYINT

*These mappings are allowed with a warning in the Director; even though values for these data types may cause an overflow or may be incompatible when applying to the target, resulting in an error. When an incorrect value is encountered the behavior depends on the SQL_MODE setting currently in effect for the Applier’s session.

MySQL Target-only Datatype

Supported Sources

BLOB 65536 bytes

DB2 (includes IBM i and UDB)

  • CHAR FOR BIT

  • BLOB (IBM i)*

 

MS SQL Server

  • BINARY

  • VARBINARY

 

Oracle

  • BLOB*

 

Sybase

  • BINARY

  • VARBINARY

*These mappings are allowed with a warning in the Director; even though values for these data types may cause an overflow or may be incompatible when applying to the target, resulting in an error. When an incorrect value is encountered the behavior depends on the SQL_MODE setting currently in effect for the Applier’s session.

MySQL Target-only Datatype

Supported Sources

CHAR and VARCHAR TEXT 65536 bytes, TINYTEXT 256 bytes

DB2 (includes IBM i and UDB)

  •    BIGINT

  •    CHAR

  •    CHAR FOR BIT. (Not valid for UDB).

  •    CLOB. (Not valid for UDB).

  •    DATE

  •    DECIMAL

  •    DOUBLE

  •    FLOAT

  •    INTEGER

  •    NUMERIC

  •    REAL

  •    SMALLINT

  •    TIME

  •    TIMESTAMP

  •    VARCHAR

  •    VARCHAR FOR BIT. (Not valid for UDB).

 

Informix

  •       CHAR

  •    DATE

  •    DATETIME

  •    DECIMAL

  •    DOUBLE PRECISION

  •    FLOAT

  •    INTEGER

  •    INTERVAL

  •    MONEY

  •    NUMERIC

  •    REAL

  •    SERIAL

  •    SMALLFLOAT

  •    SMALLINT

  •    VARCHAR

CHAR and VARCHAR

 

MS SQL Server

  •    BIGINT

  •    BIT

  •       CHAR

  •    DATE

  •    DATETIME

  •    DATETIME2(P)

  •    DATETIMEOFFSET(P)

  •    DECIMAL

  •    DOUBLE PRECISION

  •    FLOAT

  •    INTEGER

  •    MONEY

  •    NUMERIC

  •    REAL

  •    SMALLDATETIME

  •    SMALLINT

  •    SMALLMONEY

  •    TIME

  •    TINYINT

  •    VARCHAR

  •    UNIQUEIDENTIFIER

CHAR and VARCHAR

Oracle

  •       CHAR

  •    DATE

  •    DECIMAL

  •    DOUBLE PRECISION

  •    FLOAT

  •    INTEGER

  •    NUMBER

  •    NUMERIC

  •    REAL

  •    SMALLINT

  •    TIMESTAMP

  •    VARCHAR

  •    VARCHAR2

 

Sybase

  •       BIT

  •    CHAR

  •    DATETIME

  •    DECIMAL

  •    DOUBLE PRECISION

  •    FLOAT

  •    INTEGER

  •    MONEY

  •    NUMERIC

  •    REAL

  •    SMALLDATETIME

  •    SMALLINT

  •    SMALLMONEY

  •    TINYINT

  •    VARCHAR

MySQL Target-only Datatype

Supported Sources

CHAR (Unicode), VARCHAR (Unicode), NCHAR, NVARCHAR

DB2 (includes IBM i and UDB)

  • BIGINT

  • CHAR

  • CHAR (Unicode)

  • CHAR FOR BIT (Treat as CHARACTER)

  • CLOB. (Not valid for IBM i).

  • DBCLOB. (Not valid for UDB).

  • DBCLOB (Unicode)

  • DATE

  • DECIMAL

  • DOUBLE

  • FLOAT

  • GRAPHIC

  • GRAPHIC (Unicode)

  • INTEGER

  • NUMERIC

  • REAL

  • SMALLINT

  • TIME

  • TIMESTAMP

 

Informix

  •    CHAR

  •    DATE

  •    DATETIME

  •    DECIMAL

  •    DOUBLE PRECISION

  •    FLOAT

  •    INTEGER

  •    INTERVAL

  •    MONEY

  •    NCHAR

  •    NVARCHAR

  •    NUMERIC

  •    REAL

  •    SERIAL

  •    SMALLFLOAT

  •    SMALLINT

  •    VARCHAR

CHAR (Unicode), VARCHAR (Unicode), NCHAR, NVARCHAR

 

MS SQL Server

  •    BIGINT

  •    BIT

  •    CHAR

  •    DATE

  •    DATETIME

  •    DATETIME2(P)

  •    DATETIMEOFFSET(P)

  •    DECIMAL

  •    DOUBLE PRECISION

  •    FLOAT

  •    INTEGER

  •    MONEY

  •    NCHAR

  •    NTEXT

  •    NVARCHAR

  •    NVARCHAR(MAX)

  •    NUMERIC

  •    REAL

  •    SMALLDATETIME

  •    SMALLINT

  •    SMALLMONEY

  •    TIME

  •    TINYINT

  •    VARCHAR

  •    UNIQUEIDENTIFIER

CHAR (Unicode), VARCHAR (Unicode), NCHAR, NVARCHAR

Oracle

  •    CHAR

  •    DATE

  •    DECIMAL

  •    DOUBLE PRECISION

  •    FLOAT

  •    INTEGER

  •    NCHAR

  •    NCLOB

  •    NVARCHAR2

  •    NUMBER

  •    NUMERIC

  •    REAL

  •    SMALLINT

  •    TIMESTAMP

  •    VARCHAR

  •    VARCHAR2

 

Sybase

  •    BIT

  •    CHAR

  •    DATETIME

  •    DECIMAL

  •    DOUBLE PRECISION

  •    FLOAT

  •    INTEGER

  •    MONEY

  •    NUMERIC

  •    REAL

  •    SMALLDATETIME

  •    SMALLINT

  •    SMALLMONEY

  •    TINYINT

  •    VARCHAR

MySQL Target-only Datatype

Supported Sources

DATE

DB2 (includes IBM i and UDB)

  • DATE

  • TIMESTAMP

 

Informix

  • DATE

  • DATETIME

 

MS SQL Server

  • DATE

  • DATETIME

  • DATETIME2(P)

  • DATETIMEOFFSET(P)

  • SMALLDATETIME

  Oracle
  • DATE

  • TIMESTAMP

 

Sybase

  • DATETIME

  • SMALLDATETIME

Note: The standard display format for the MySQL DATE datatype is YYYY-MM-DD. Data is accepted without the embedded hyphens.

MySQL Target-only Datatype

Supported Sources

DATETIME (p)

(Maximum of 6 fractional

seconds)

DB2 (includes IBM i and UDB)

  • DATE

  • TIMESTAMP

 

Informix

  • DATE

  • DATETIME

DATETIME (p)

MS SQL Server

  • DATE

  • DATETIME

  • DATETIME2(P)

  • DATETIMEOFFSET(P)

  • SMALLDATETIME. Time generated as all zero's.

  • TIME(P)

 

Oracle

  • DATE

  • TIMESTAMP

 

Sybase

  • DATETIME

  • SMALLDATETIME

Note: The format for the DATETIME column is YYYY-MM-DD HH:MM:SS[.fraction]. Unlike the TIMESTAMP column, the value is not stored in UTC.

MySQL Target-only Datatype

Supported Sources

DECIMAL (p,s) and NUMERIC(p,s)

DB2 (includes IBM i and UDB)

  • BIGINT

  • DECIMAL

  • DOUBLE

  • FLOAT

  • INTEGER

  • NUMERIC (p,s)

  • REAL

  • SMALLINT.

 

Informix

  • DECIMAL

  • DOUBLE PRECISION

  • FLOAT

  • INTEGER

  • MONEY

  • NUMERIC

  • REAL

  • SERIAL

  • SMALLFLOAT

  • SMALLINT

 

MS SQL Server

  • BIGINT

  • BIT

  • DECIMAL

  • DOUBLE PRECISION

  • FLOAT

  • INTEGER

  • MONEY

  • NUMERIC

  • REAL

  • SMALLINT

  • SMALLMONEY

  • TINYINT

DECIMAL (p,s) and NUMERIC(p,s)

Oracle

  • DECIMAL

  • DOUBLE PRECISION

  • FLOAT

  • INTEGER

  • NUMBER

  • NUMERIC

  • REAL

  • SMALLINT

 

Sybase

  • BIT

  • DECIMAL

  • DOUBLE PRECISION

  • FLOAT

  • INTEGER

  • MONEY

  • NUMERIC

  • REAL

  • SMALLINT

  • SMALLMONEY.

  • TINYINT

Note: The data types DEC and NUMERIC are aliases for DECIMAL. All of the supported source datatypes may result in run time errors, depending on the precision and scale specified on the target decimal columns. When an incorrect value is encountered, the behavior depends on the SQL_MODE setting currently in effect for the Applier's session. The Director should use the precision and scale to determine when a warning should be issued.

MySQL Target-only Datatype

Supported Sources

DOUBLE (p,s), FLOAT (p,s), REAL (p,s)

DB2 (includes IBM i and UDB)

  • BIGINT

  • DECIMAL

  • DOUBLE

  • FLOAT

  • INTEGER

  • NUMERIC

  • REAL

  • SMALLINT

 

Informix

  • DECIMAL

  • DOUBLE PRECISION

  • FLOAT

  • INTEGER

  • MONEY

  • NUMERIC

  • REAL

  • SERIAL

  • SMALLFLOAT

  • SMALLINT

 

MS SQL Server

  • BIGINT

  • BIT

  • DECIMAL

  • DOUBLE PRECISION

  • FLOAT

  • INTEGER

  • MONEY

  • NUMERIC

  • REAL

  • SMALLMONEY

  • SMALLINT

  • TINYINT

FLOAT (p,s)

DOUBLE (p,s)

REAL (p,s)

Oracle

  • DECIMAL

  • DOUBLE PRECISION

  • FLOAT

  • INTEGER

  • NUMBER

  • NUMERIC

  • REAL

  • SMALLINT

 

Sybase

  • BIT

  • DECIMAL

  • DOUBLE PRECISION

  • FLOAT

  • INTEGER

  • MONEY

  • NUMERIC

  • REAL

  • SMALLMONEY

  • SMALLINT

  • TINYINT

MySQL Target-only Datatype

Supported Sources

INT

 

DB2 (includes IBM i and UDB)

  • BIGINT *

  • DOUBLE *

  • FLOAT*

  • INTEGER

  • NUMERIC*

  • REAL*

  • SMALLINT

 

Informix

  • DECIMAL*

  • DOUBLE PRECISION*

  • FLOAT*

  • INTEGER

  • MONEY*

  • NUMERIC*

  • REAL*

  • SERIAL*

  • SMALLFLOAT*

  • SMALLINT

INT

MS SQL Server

  • BIGINT*

  • BIT

  • DECIMAL*

  • DOUBLE PRECISION*

  • FLOAT*

  • INTEGER

  • MONEY*

  • NUMERIC*

  • REAL*

  • SMALLMONEY*

  • SMALLINT

  • TINYINT

 

Oracle

  • DECIMAL*

  • DOUBLE PRECISION*

  • FLOAT*

  • INTEGER

  • NUMBER*

  • NUMERIC*

  • REAL*

  • SMALLINT

 

Sybase

  • BIT

  • DECIMAL*

  • DOUBLE PRECISION*

  • FLOAT*

  • INTEGER

  • MONEY*

  • NUMERIC*

  • REAL*

  • SMALL MONEY*

  • SMALLINT

  • TINYINT

*These mappings are allowed with a warning in the Director; even though values for these data types may cause an overflow or may be incompatible when applying to the target, resulting in an error. When an incorrect value is encountered the behavior depends on the SQL_MODE setting currently in effect for the Applier’s session.

 

MySQL Target-only Datatype

Supported Sources

LONGBLOB

(4,294,967,296 bytes)

DB2 (includes IBM i and UDB)

  • CHAR FOR BIT

  • BLOB (IBM i)

 

MS SQL Server

  • BINARY

  • IMAGE

  • VARBINARY

  • VARBINARY(MAX)

 

Oracle

  • BLOB

 

Sybase

  • BINARY

  • IMAGE

  • VARBINARY

MySQL Target-only Datatype

Supported Sources

LONGTEXT 4,294,967,296 bytes, MEDIUMTEXT   16,777,216 bytesTINYTEXT

 

DB2 (includes IBM i and UDB)

  • CHAR

  • CHAR (Unicode)

  • CHAR FOR BIT (Treat as CHARACTER). (Not valid for UDB).

  • CLOB. (Not valid for UDB). (Not valid for TINYTEXT for IBM i).

  • DBCLOB. (Not valid for UDB)

  • DBCLOB (Unicode)

  • GRAPHIC

  • GRAPHIC (Unicode)

  • VARCHAR

  • VARGRAPHIC

  • VARCHAR FOR BIT. (Not valid for UDB).

 

Informix

  • CHAR

  • NCHAR

  • NVARCHAR

  • VARCHAR

LONGTEXT 4,294,967,296 bytes, MEDIUMTEXT   16,777,216 bytesTINYTEXT

 

MS SQL Server

  • CHAR

  • NCHAR

  • NTEXT

  • NVARCHAR

  • NVARCHAR(MAX)

  • TEXT

  • VARCHAR

  • VARCHAR (MAX).

 

Oracle

  • CHAR

  • CLOB. (Not valid for TINYTEXT).

  • NCHAR

  • NCLOB

  • NVARCHAR2

  • VARCHAR

  • VARCHAR2

 

Sybase

  • CHAR

  • VARCHAR

Note: MySQL has four different TEXT types for character-based large objects, where each type differs only in size. A TEXT type holds a variable size character string that is defined with a character set. When applying to one of the BLOB types, if the target value is larger than the target column allows, the value is truncated to fit the target column.

MySQL Target-only Datatype

Supported Sources

LONGTEXT (Unicode) and MEDIUMTEXT (Unicode)TINYTINYTEXT

 

DB2 (includes IBM i and UDB)

  • CHAR a

  • DBCLOB ((Unicode for IBM i only)

  • GRAPHIC a

  • VARCHAR a

  • VARGRAPHIC a

Informix

LONGTEXT (Unicode) and MEDIUMTEXT (Unicode)TINYTINYTEXT

MS SQL Server

  • NCHAR a

  • NTEXT

  • NVARCHAR a

  • NVARCHAR(MAX)

 

Oracle

  • NCHAR a

  • NVARCHAR2 a 

  Sybase
 

Teradata

  • CHAR a

  • LONG VARCHAR a

  • VARCHAR a

aIndicates that Connect CDC Director will issue a warning of possible trun­cation of data at the target.

MySQL Target-only Datatype

Supported Sources

MEDIUMBLOB

16,777,216 bytes

DB2 (includes IBM i and UDB)

  • CHAR FOR BIT

  • BLOB (IBM i)*

 

MS SQL Server

  • BINARY

  • IMAGE*

  • VARBINARY

  • VARBINARY(MAX)*

 

Oracle

  • BLOB*

 

Sybase

  • BINARY

  • IMAGE*

  • VARBINARY

*These mappings are allowed with a warning in the Director; even though values for these data types may cause an overflow or may be incompatible when applying to the target, resulting in an error. When an incorrect value is encountered the behavior depends on the SQL_MODE setting currently in effect for the Applier’s session.

MySQL Target-only Datatype

Supported Sources

MEDIUMINT

(3 bytes)

DB2 (includes IBM i and UDB)

  • BIGINT *

  • DECIMAL *

  • DOUBLE *

  • FLOAT*

  • INTEGER

  • NUMERIC*

  • REAL*

  • SMALLINT

 

Informix

  • DECIMAL*

  • DOUBLE PRECISION*

  • FLOAT*

  • INTEGER

  • MONEY*

  • NUMERIC*

  • REAL*

  • SERIAL*

  • SMALLFLOAT*

  • SMALLINT

MEDIUMINT

(3 bytes)

MS SQL Server

  • BIGINT*

  • BIT

  • DECIMAL*

  • DOUBLE PRECISION*

  • FLOAT*

  • INTEGER

  • MONEY*

  • NUMERIC*

  • REAL*

  • SMALLMONEY*

  • SMALLINT

  • TINYINT

 

Oracle

  • DECIMAL*

  • DOUBLE PRECISION*

  • FLOAT*

  • INTEGER

  • NUMBER*

  • NUMERIC*

  • REAL*

  • SMALLINT

 

Sybase

  • BIT

  • DECIMAL*

  • DOUBLE PRECISION*

  • FLOAT*

  • INTEGER

  • MONEY*

  • NUMERIC*

  • REAL*

  • SMALL MONEY*

  • SMALLINT

  • TINYINT

*These mappings are allowed with a warning in the Director; even though values for these data types may cause an overflow or may be incompatible when applying to the target, resulting in an error. When an incorrect value is encountered the behavior depends on the SQL_MODE setting currently in effect for the Applier’s session.

MySQL Target-only Datatype

Supported Sources

SMALLINT

(2 bytes)

DB2 (includes IBM i and UDB)

  • BIGINT *

  • DECIMAL *

  • DOUBLE *

  • FLOAT*

  • INTEGER

  • NUMERIC*

  • REAL*

  • SMALLINT

 

Informix

  • DECIMAL*

  • DOUBLE PRECISION*

  • FLOAT*

  • INTEGER

  • MONEY*

  • NUMERIC*

  • REAL*

  • SERIAL*

  • SMALLFLOAT*

  • SMALLINT

SMALLINT

(3 bytes)

MS SQL Server

  • BIGINT*

  • BIT

  • DECIMAL*

  • DOUBLE PRECISION*

  • FLOAT*

  • INTEGER

  • MONEY*

  • NUMERIC*

  • REAL*

  • SMALLMONEY*

  • SMALLINT

  • TINYINT

 

Oracle

  • DECIMAL*

  • DOUBLE PRECISION*

  • FLOAT*

  • INTEGER

  • NUMBER*

  • NUMERIC*

  • REAL*

  • SMALLINT

 

Sybase

  • BIT

  • DECIMAL*

  • DOUBLE PRECISION*

  • FLOAT*

  • INTEGER

  • MONEY*

  • NUMERIC*

  • REAL*

  • SMALL MONEY*

  • SMALLINT

  • TINYINT

*These mappings are allowed with a warning in the Director; even though values for these data types may cause an overflow or may be incompatible when applying to the target, resulting in an error. When an incorrect value is encountered the behavior depends on the SQL_MODE setting currently in effect for the Applier’s session.

 

MySQL Target-only Datatype

Supported Sources

TIME(P)

(Maximum of 6 fractional seconds)

DB2 (includes IBM i and UDB)

  • TIME

  • TIMESTAMP

 

Informix

  • DATETIME

 

MS SQL Server

  • DATETIME

  • DATETIME2(P)

  • DATETIMEOFFSET(P)

  • SMALLDATETIME

  • TIME

  • TIME(P)

 

Oracle

  • DATE

  • TIMESTAMP

 

Sybase

  • DATETIME

  • SMALLDATETIME

MySQL Target-only Datatype

Supported Sources

TIMESTAMP

(Maximum of 6 fractional seconds)

DB2 (includes IBM i and UDB)

  • DATE

  • TIMESTAMP

 

Informix

  • DATE

  • DATETIME

 

MS SQL Server

  • DATE

  • DATETIME

  • DATETIME2(P)

  • DATETIMEOFFSET(P)

  • SMALLDATETIME

  • TIME(P)

 

Oracle

  • DATE

  • TIMESTAMP

 

Sybase

  • DATE

  • DATETIME

  • SMALLDATETIME

MySQL Target-only Datatype

Supported Sources

TIMESTAMP (P)

DB2 (includes IBM i and UDB)

  • DATE

  • TIME

  • TIMESTAMP

 

Informix

  • DATE

  • DATETIME

 

MS SQL Server

  • DATE

  • DATETIME

  • DATETIME2(P)

  • DATETIMEOFFSET(P)

  • SMALLDATETIME

  • TIME

  • TIME(P)

 

Oracle

  • DATE

  • TIMESTAMP

  • TIMESTAMP (P)

 

Sybase

  • DATETIME

  • SMALLDATETIME

MySQL Target-only Datatype

Supported Sources

TINYBLOB

(256 bytes)

DB2 (includes IBM i and UDB)

  • CHAR FOR BIT

  • BLOB (IBM i)*

 

MS SQL Server

  • BINARY

  • VARBINARY

 

Sybase

  • BINARY

  • VARBINARY

*These mappings are allowed with a warning in the Director; even though values for these data types may cause an overflow or may be incompatible when applying to the target, resulting in an error. When an incorrect value is encountered the behavior depends on the SQL_MODE setting currently in effect for the Applier’s session.

MySQL Target-only Datatype

Supported Sources

TINYINT

(1 byte)

DB2 (includes IBM i and UDB)

  • BIGINT *

  • DOUBLE *

  • FLOAT*

  • INTEGER

  • NUMERIC*

  • REAL*

  • SMALLINT

 

Informix

  • DECIMAL*

  • DOUBLE PRECISION*

  • FLOAT*

  • INTEGER

  • MONEY*

  • NUMERIC*

  • REAL*

  • SERIAL*

  • SMALLFLOAT*

  • SMALLINT

TINYINT

(1 byte)

MS SQL Server

  • BIGINT*

  • BIT

  • DECIMAL*

  • DOUBLE PRECISION*

  • FLOAT*

  • INTEGER*

  • MONEY*

  • NUMERIC*

  • REAL*

  • SMALL MONEY*

  • SMALLINT*

  • TINYINT

 

Oracle

  • DECIMAL*

  • DOUBLE PRECISION*

  • FLOAT*

  • INTEGER

  • NUMBER*

  • NUMERIC*

  • REAL*

  • SMALLINT

 

Sybase

  • BIT

  • DECIMAL*

  • DOUBLE PRECISION*

  • FLOAT*

  • INTEGER

  • MONEY*

  • NUMERIC*

  • REAL*

  • SMALL MONEY*

  • SMALLINT

  • TINYINT

*These mappings are allowed with a warning in the Director; even though values for these data types may cause an overflow or may be incompatible when applying to the target, resulting in an error. When an incorrect value is encountered the behavior depends on the SQL_MODE setting currently in effect for the Applier’s session.

MySQL Target-only Datatype

Supported Sources

VARBINARY (m)

M = number of bytes, max 65,535

DB2 (includes IBM i and UDB)

  • CHAR FOR BIT

  • BLOB ( IBM i ) *

 

MS SQL Server

  • BINARY

 

Sybase

  • BINARY

  • VARBINARY

*These mappings are allowed with a warning in the Director; even though values for these data types may cause an overflow or may be incompatible when applying to the target, resulting in an error. When an incorrect value is encountered the behavior depends on the SQL_MODE setting currently in effect for the Applier’s session.

MySQL Target-only Datatype

Supported Sources

YEAR

(Precision indicates number of digits. Can be either 2 or 4)

DB2 (includes IBM i and UDB)

  • DATE

  • TIMESTAMP

 

Informix

  • DATE

  • DATETIME

 

MS SQL Server

  • DATE

  • DATETIME

  • DATETIME2(P)

  • DATETIMEOFFSET(P)

  • SMALLDATETIME

 

Oracle

  • DATE

  • TIMESTAMP

 

Sybase

  • DATETIME

  • SMALLDATETIME