Data Ingestion and Replication
- Data Ingestion and Replication
- All Products
ASK INFAPreview
Please log in to access Ask INFA.
ASK INFAPreview
MySQL Source Data Type
| Synapse Analytics Target Data Type
|
|---|---|
bigint
| bigint
|
bigint unsigned
| decimal(20)
|
binary( size ), 1 <= s <= 255
| binary( size ), 1 <= s <= 255
|
bit
| bit
|
bit( precision ), 1 <= p <= 64
| binary( size ), 1 <= s <= 8
|
blob
| varbinary(max)
|
char( size ), 1 <= s <= 255
| varchar( size ), 4 <= s <= 1020
|
date
| date
|
datetime
| datetime2
|
decimal(p,s), 1 <= p <= 38, 0 <= s <= 29
| decimal(p,s), 1 <= p <= 38, 0 <= s <= 29
|
decimal(p,s), 39 <= p <= 65, 0 <= s <= 29
| char( size ), 40 <= s <= 67
|
double
| float
|
float
| real
|
geomcollection
| varbinary(max)
|
geometry
| varbinary(max)
|
geometrycollection
| varbinary(max)
|
int
| int
|
int unsigned
| bigint
|
json
| varchar(max)
|
linestring
| varbinary(max)
|
longblob
| varbinary(max)
|
longtext
| varchar(max)
|
mediumblob
| varbinary(max)
|
mediumint
| int
|
mediumint unsigned
| int
|
mediumtext
| varchar(max)
|
multilinestring
| varbinary(max)
|
multipoint
| varbinary(max)
|
multipolygon
| varbinary(max)
|
numeric
| decimal(10)
|
point
| varbinary(max)
|
polygon
| varbinary(max)
|
smallint
| smallint
|
smallint unsigned
| int
|
text
| varchar(max)
|
time( precision ), 0 <= p <= 6
| varchar( size ), 10 <= s <= 17
|
timestamp( precision ), 0 <= p <= 3
| datetime2
|
timestamp( precision ), 4 <= p <= 6
| datetime2( precision ), 4 <= p <= 6
|
tinyblob
| binary(255)
|
tinyint
| smallint
|
tinyint unsigned
| smallint
|
tinytext
| char(256)
|
varbinary( size ), 1 <= s <= 65535
| varbinary( size ), 1 <= s <= max
|
varchar( size ), 1 <= s <= 21844
| varchar( size ), 4 <= s <= max
|
year
| smallint
|
