Datatype Conversion - MySQL to Access
| MySQL | Access | Remarks |
|---|
| BIT
|
BINARY(8)
|
|
| TINYINT
|
SMALLINT
|
|
| BOOL/BOOLEAN
|
BIT
|
|
| SMALLINT
|
SMALLINT
|
|
| MEDIUMINT
|
INTEGER
|
|
| INT/INTEGER
|
INTEGER
|
|
| BIGINT
|
DECIMAL/INTEGER
(if autoincrement)
|
|
| FLOAT
|
REAL
|
|
| REAL/DOUBLE
|
FLOAT
|
|
| DEC/DECIMAL
|
DECIMAL
|
May truncate
|
|
|
|
|
| DATE
|
DATETIME
|
|
| TIME
|
DATETIME
|
|
| DATETIME
|
DATETIME
|
|
| YEAR(2|4)
|
DATETIME
|
|
| TIMESTAMP
|
DATETIME
|
|
|
|
|
|
| CHAR
|
CHARACTER
|
|
| VARCHAR/CHARACTER
VARYING
|
TEXT
|
|
| BINARY
|
BINARY
|
|
| VARBINARY
|
IMAGE
|
|
| TINYBLOB
|
BINARY
|
|
| BLOB/TEXT
|
IMAGE/TEXT
|
|
| MEDIUMBLOB/MEDIUMTEXT
|
IMAGE/TEXT
|
|
| LONGBLOB/LONGTEXT
|
IMAGE/TEXT
|
Length of BLOB in Access is 2^30, truncates when size in MySQL is larger.
|
| ENUM('v1',
'v2',...)
|
SMALLINT
|
|
| SET('v1',
'v2',...)
|
DECIMAL
|
|
|
Datatype Conversion - Access to MySQL
| Access | MySQL | Remarks |
|---|
|
BIT
|
BOOLEAN
|
|
|
TINYINT
|
TINYINT
UNSIGNED
|
|
|
SMALLINT
|
SMALLINT
|
|
|
INTEGER
|
INT
|
|
|
|
|
|
|
MONEY
|
DECIMAL
|
|
|
DECIMAL
|
DECIMAL
|
|
|
|
|
|
|
DATETIME
|
DATETIME
|
May truncate
|
|
UNIQUEIDENTIFIER
|
BINARY(16)
|
|
|
REAL
|
FLOAT
|
|
|
FLOAT
|
DOUBLE
|
|
|
|
|
|
|
BINARY/CHARACTER
|
VARBINARY/VARCHAR
|
|
|
TEXT/IMAGE
|
LONGBLOB/LONGTEXT
|
May truncate
|
|
Datatype Conversion - MySQL to MS SQLServer
| MySQL | MS SQLServer | Remarks |
|---|
|
BIT
|
BINARY(8)
|
|
|
TINYINT
|
TINYINT/SMALLINT
(if unsigned)
|
|
|
BOOL/BOOLEAN
|
BIT
|
|
|
SMALLINT
|
SMALLINT/INT
(if unsigned)
|
|
|
MEDIUMINT
|
INTEGER
|
|
|
INT/INTEGER
|
INTEGER/BIGINT
(if unsigned)
|
|
|
BIGINT
|
BIGINT/DECIMAL
(if unsigned)
|
|
|
SERIAL
|
DECIMAL
|
|
|
FLOAT
|
FLOAT
|
|
|
REAL/DOUBLE
|
REAL
|
|
|
DEC/DECIMAL
|
DECIMAL
|
May truncate
|
|
|
|
|
|
DATE
|
DATETIME
|
|
|
TIME
|
DATETIME
|
|
|
DATETIME
|
DATETIME
|
|
|
YEAR(2|4)
|
DATETIME
|
|
|
TIMESTAMP
|
DATETIME
|
|
|
|
|
|
|
CHAR(n)
|
NCHAR(n)
|
|
|
VARCHAR(n)/CHARACTER
VARYING
|
NVARCHAR(n)
|
|
|
BINARY(n)
|
BINARY(n)
|
|
|
VARBINARY(n)
|
VARBINARY(n)
|
|
|
TINYBLOB
|
BINARY(256)
|
|
|
BLOB/TEXT
|
IMAGE/NTEXT
|
|
|
MEDIUMBLOB/MEDIUMTEXT
|
IMAGE/NTEXT
|
|
|
LONGBLOB/LONGTEXT
|
IMAGE/NTEXT
|
May truncate
|
|
ENUM('v1',
'v2',...)
|
NVARCHAR(255)
|
|
|
SET('v1',
'v2',...)
|
NVARCHAR(255)
|
|
|
Datatype Conversion - MS SQLServer to MySQL
| MS SQLServer | MySQL | Remarks |
|---|
|
BIGINT
|
BIGINT
|
|
|
|
INT
|
INT/INTEGER
|
|
|
|
SMALLINT
|
SMALLINT
|
|
|
|
TINYINT
|
TINYINT
|
|
|
|
BIT
|
BOOL
|
|
|
|
DECIMAL/NUMERIC
|
DECIMAL/BIGINT
(if autoincrement)
|
May
truncate
|
|
|
MONEY
|
DECIMAL
|
|
|
|
SMALLMONEY
|
DECIMAL
|
|
|
|
|
|
|
|
|
FLOAT
|
FLOAT
|
|
|
|
REAL
|
REAL/DOUBLE
|
|
|
|
|
|
|
|
|
DATETIME
|
DATETIME
|
|
|
|
SMALLDATETIME
|
DATETIME
|
|
|
|
|
|
|
|
|
char(n)
|
VARCHAR(n)
|
N<256
|
|
|
char(n)
|
TEXT
|
n>255
|
|
|
nchar(n)
|
VARCHAR(n)
|
N<256
|
Collation
for unicode
|
|
nchar(n)
|
TEXT
|
n>255
|
Collation
for unicode
|
|
varchar(n|max)
|
LONGTEXT
|
|
|
|
Nvarchar(n|max)
|
LONGTEXT
|
|
|
|
Text
|
LONGTEXT
|
|
|
|
Ntext
|
LONGTEXT
|
|
Collation
for unicode
|
|
|
|
|
|
|
binary(n)
|
VARBINARY
|
N<256
|
|
|
binary(n)
|
LONGBLOB
|
n>255
|
|
|
Varbinary(n|max)
|
VARBINARY
|
N<256
|
|
|
Varbinary(n|max)
|
LONGBLOB
|
n>255
|
|
|
Image
|
LONGBLOB
|
|
|
|
|
|
|
|
|
Uniqueidentifier
|
BINARY(16)
|
|
|
|
Timestamp
|
BINAY(8)
|
|
|
|
Xml
|
LONGTEXT
|
|
|
|
sql_variant
|
LONGTEXT
|
|
|
|
Detailed Technical Information:
imprint
