MySQL to MySQL mapping
AutoSync maps MySQL column types to the following MySQL column types:
Source MySQL column type | Destination MySQL column type |
---|---|
BIT |
VARCHAR |
TINYINT |
TINYINT |
TINYINT UNSIGNED |
TINYINT UNSIGNED |
SMALLINT |
SMALLINT |
SMALLINT UNSIGNED |
SMALLINT UNSIGNED |
MEDIUMINT |
MEDIUMINT |
MEDIUMINT UNSIGNED |
MEDIUMINT UNSIGNED |
INT |
INT |
INT UNSIGNED |
INT UNSIGNED |
BIGINT |
BIGINT |
BIGINT UNSIGNED |
BIGINT UNSIGNED |
DECIMAL |
DECIMAL |
FLOAT |
FLOAT |
DOUBLE |
DOUBLE |
DATE |
DATE |
DATETIME |
DATETIME |
TIMESTAMP |
DATETIME |
TIME |
TIME |
YEAR |
SMALLINT |
CHAR |
CHAR |
VARCHAR |
VARCHAR |
BINARY |
BLOB |
VARBINARY |
BLOB |
BLOB |
BLOB |
TINYBLOB |
BLOB |
MEDIUMBLOB |
BLOB |
LONGBLOB |
BLOB |
TEXT |
VARCHAR |
TINYTEXT |
VARCHAR |
MEDIUMTEXT |
VARCHAR |
LONGTEXT |
VARCHAR |
JSON |
VARCHAR |
GEOMETRY |
JSON |
sl_timestamp |
DATETIME |