Azure Synapse to MySQL mapping
AutoSync maps Azure Synapse object types to the following MySQL column types:
Azure Synapse object type | MySQL column type |
---|---|
bit |
BIT |
date |
DATE |
datetime |
DATETIME |
datetime2 |
DATETIME |
smalldatetime |
DATETIME |
datetimeoffset |
DATETIME |
time |
TIME |
sl_timestamp |
DATETIME |
decimal |
DECIMAL |
numeric |
DECIMAL |
float |
DOUBLE |
real |
DOUBLE |
tinyint |
TINYINT UNSIGNED |
smallint |
SMALLINT |
int |
INT |
bigint |
BIGINT |
money |
DECIMAL |
smallmoney |
DECIMAL |
char |
CHAR |
nchar |
CHAR |
nvarchar |
VARCHAR |
uniqueidentifier |
VARCHAR |
varchar |
VARCHAR |
binary |
VARCHAR |
varbinary |
VARCHAR |