MySQLソースデータ型 | Microsoft SQL Serverターゲットデータ型 |
|---|---|
bigint | bigint |
bigint unsigned | decimal(20,0) |
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), 3 <= size <= 765 |
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 <= size <= 67 |
倍精度浮動小数点数型 | 浮動小数点数型 |
浮動小数点数型 | real |
geomcollection | binary(8000) |
geometry | varbinary(max) |
geometrycollection | varbinary(max) |
int | int |
int unsigned | bigint |
json | nvarchar(max) |
linestring | varbinary(max) |
longblob | varbinary(max) |
longtext | nvarchar(max) |
mediumblob | varbinary(max) |
mediumint | int |
mediumint unsigned | int |
mediumtext | nvarchar(max) |
multilinestring | varbinary(max) |
multipoint | varbinary(max) |
multipolygon | varbinary(max) |
numeric(10,0) | decimal(10,0) |
point | varbinary(max) |
polygon | varbinary(max) |
smallint | smallint |
smallint unsigned | int |
text | nvarchar(max) |
time(precision), 0 <= p <= 6 | varchar(size), 10 <= size <= 17 |
timestamp(precision), 0 <= p <= 3 | datetime2 |
timestamp(precision), 4 <= p <= 6 | datetime2(precision), 4 <= p <= 6 |
tinyblob | varbinary |
tinyint | smallint |
tinyint unsigned | tinyint |
tinytext | nvarchar |
varbinary(size), 1 <= size <= 65535 | varbinary(size), 1 <= size <= max |
varchar(size), 1 <= size <= 21844 | varchar(size), 3 <= size <= max |
year | smallint |