|
MySql Type
|
Sql Server 2008 Mappings
|
Remarks
|
Alternatives
|
|
TINYINT (M)
|
tinyint
|
M is the number of decimal
places in the output for this value.
|
tinyint,
smallint, int, bigint, numeric(p,s), decimal(p,s), float(p),
double precision, real,
|
|
TINYINT (1)
|
|
|
smallmoney,money
|
|
SMALLINT (M)
|
smallint
|
M is the number of decimal
places in the output for this value.
|
tinyint,
smallint, int, bigint, numeric(p,s), decimal(p,s), float(p),
double precision, real, smallmoney, money
|
|
MEDIUMINT (M)
|
int
|
M is the number of decimal
places in the output for this value.
|
tinyint,
smallint, int, bigint, numeric(p,s), decimal(p,s), float(p),
double precision, real, smallmoney, money
|
|
INT (M)
INTEGER (M)
|
int
|
M is the number of decimal
places in the output for this value.
|
tinyint,
smallint, int, bigint, numeric(p,s), decimal(p,s), float(p),
double precision, real, smallmoney, money
|
|
BIGINT (M)
|
bigint
|
M is the number of decimal
places in the output for this value.
|
tinyint,
smallint, int, bigint, numeric(p,s), decimal(p,s), float(p),
double precision, real, smallmoney, money
|
|
FLOAT (P)
|
float(P)
|
N/A
|
numeric(p,s),
decimal(p,s), float(p), double precision, real, smallmoney, money
|
|
FLOAT [(P, S)]
|
float(24)
|
(P,S)” means that values are
displayed with up to P digits total, of which S digits may be after the
decimal point. MySQL performs rounding when storing values.
|
numeric(p,s), decimal(p,s),
float(p), double precision, real, smallmoney, money
|
|
DATETIME [(D)]
|
datetime2
|
MySQL store dates from
0000-00-00 to 9999-12-31. MySQL can store zero-value of year, month, and
year.
|
smalldatetime,datetime
|
|
DATE [(D)]
|
date
|
|
smalldatetime, datetime,
datetime2, date
|
|
TIME
|
time
|
Range is '-838:59:59' to
'838:59:59'.
|
smalldatetime,datetime,
time,varchar,nvarchar
|
|
TIMESTAMP
|
smalldatetime
|
|
datetime, datetime2, rowversion,
timestamp, varbinary(8), binary(8)
|
|
[NATIONAL] CHAR (N)
|
nchar(N)
|
Range of N is 0 to 255
characters.
|
char, varchar, nchar, nvarchar
|
|
TINYTEXT
|
nvarchar(255)
|
None
|
char, varchar, nchar, nvarchar
|
|
MEDIUMTEXT
|
nvarchar(max)
|
None
|
char, varchar, nchar, nvarchar,
varchar(max), nvarchar(max)
|
|
BINARY (N)
|
binary(N)
|
None
|
binary, varbinary, char,
varchar, nchar, nvarchar
|
|
TINYBLOB
|
varbinary(255)
|
None
|
binary, varbinary, varbinary(max)
|
|
BLOB (N)
|
varbinary (N | max)
|
A BLOB column with a maximum
length of 65,535 bytes.
|
binary, varbinary, varbinary(max)
|