Use Mysql Database as the DTS Destination
Last Updated:2020-09-01
Mysql Data Types Supported by DTS
The following table lists the Mysql data types supported when using DTS and the default mapping to DTS data types.
DTS field type | MYSQL data type |
---|---|
DTS_TYPE_INT1 | TINYINT |
DTS_TYPE_INT2 | SMALLINT |
DTS_TYPE_INT4 | INT |
DTS_TYPE_INT8 | BIGINT |
DTS_TYPE_NUMBER | If precision <= 65 && scale <= 30, use DECIMAL (p, s) ; otherwise use varchar, character set ACSII |
DTS_TYPE_FLOAT | FLOAT |
DTS_TYPE_DOUBLE | DOUBLE |
DTS_TYPE_BYTES | If the fixed length && byte length <= 255 bytes, use BINARY ; if the byte length <= 65536 bytes, use VARBINARY ; if the byte length <= 16,777,215 bytes, use MEDIUMBLOB ; otherwise, use LONGBLOB. |
DTS_TYPE_DATE | DATE |
DTS_TYPE_TIME | If decimal places => 0 and <= 6, use TIME (Scale) ; if decimal places => 7 and <= 9, use VARCHAR (37), character set ACSII; |
DTS_TYPE_DATETIME | If decimal places => 0 and <= 6, use DATETIME (Scale) ; if decimal places => 7 and <= 9, use VARCHAR (37), character set ACSII |
DTS_TYPE_STRING | If fixed-length && byte length <= 255 bytes, use CHAR ; if byte length <= 65536 bytes, use VARCHAR ; if byte length <= 16,777,215 bytes, use MEDIUMTEXT; otherwise, use LONGTEXT |