Mass Ingestion
- Mass Ingestion
- 所有产品
MySQLソースデータ型
| Microsoft Azure Synapse Analyticsターゲットデータ型
|
---|---|
bigint
| bigint
|
bigint unsigned
| decimal(20)
|
binary( size ), 1 <= size <= 255
| binary( size ), 1 <= size <= 255
|
bit
| bit
|
bit( precision ), 1 <= p <= 64
| binary( size ), 1 <= size <= 8
|
blob
| varbinary(max)
|
char( size ), 1 <= size <= 255
| varchar( size ), 4 <= size <= 1020
|
date
| date
|
datetime
| datetime2(0)
|
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 <= size <= 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 <= size <= 17
|
timestamp( precision ), 0 <= p <= 6
| datetime2( precision ), 0 <= p <= 6
|
tinyblob
| binary(255)
|
tinyint
| smallint
|
tinyint unsigned
| smallint
|
tinytext
| char(256)
|
varbinary( size ), 1 <= size <= 65535
| varbinary( size ), 1 <= size <= max
|
varchar( size ), 1 <= size <= 21844
| varchar( size ), 4 <= size <= max
|
year
| smallint
|