Numeric types | |||||
Access | MySQL | MSSQL | |||
Byte | 1 byte | TINYINT(size) | bigint | 1 byte | |
Integer | 2 bytes | SMALLINT(size) | smallint | 2 bytes | |
Long | 4 bytes | MEDIUMINT(size) | int | 4 bytes | |
Single | 4 bytes | INT(size) | bigint | 8 bytes | |
Double | 8 bytes | BIGINT(size) | decimal(p,s) | 5-17 bytes | |
Currency | 8 bytes | FLOAT(size,d) | numeric(p,s) | 5-17 bytes | |
AutoNumber | 4 bytes | DOUBLE(size,d) | smallmoney | 4 bytes | |
DECIMAL(size,d) | money | 8 bytes | |||
float(n) | 4 or 8 bytes | ||||
real | 4 bytes |
String / text types | |||||
Access | MySQL | MSSQL | |||
Text | CHAR(size) | char(n) | Defined width | ||
Memo | VARCHAR(size) | varchar(n) | 2 bytes + number of chars | ||
Byte | 1 byte | TINYTEXT | varchar(max) | 2 bytes + number of chars | |
TEXT | text | 4 bytes + number of chars | |||
nchar | Defined width x 2 | ||||
nvarchar | |||||
nvarchar(max) | |||||
ntext | |||||
bit | |||||
binary(n) | |||||
varbinary | |||||
varbinary(max) | |||||
image |
Date types | |||||
Access | MySQL | MSSQL | |||
Date/Time | 8 bytes | DATE() | datetime | 8 bytes | |
DATETIME() | datetime2 | 6-8 bytes | |||
TIMESTAMP() | smalldatetime | 4 bytes | |||
TIME() | date | 3 bytes | |||
YEAR() | time | 3-5 bytes | |||
datetimeoffset | 8-10 bytes | ||||
timestamp |
Other data types | |||||
Access | MySQL | MSSQL | |||
Yes/No | 1 bit | sql_variant | |||
Ole Object | up to 1GB | uniqueidentifier | |||
Hyperlink | xml | ||||
Lookup Wizard | 4 bytes | cursor | |||
table |