Home >
Documentation >
MS Access to MySQL
Microsoft Access to MySQL Types Mapping |
| [Access to MySQL Converter] [About Migration] [Converting Queries] |
Microsoft Access and MySQL have similar set of data types. Some of them are compatible with each other while the rest are not. When planning Access to MySQL migration it is important to have in mind the following compatibility matrix for data types of Microsoft Access and MySQL. In the table below all valid type mappings are marked green (with restriction on data if any), every prohibited or dangerous type mapping is marked orange.
 |
TEXT | MEMO | BYTE | INTEGER | Long | Single | Double | Currency | Auto Number | Date/Time | Yes/No | Ole Object | Hyperlink | Lookup Wizard |
| CHAR | dest. length >= source length | Possible truncation of text | URL text | |||||||||||
| VARCHAR | dest. length >= source length | Possible truncation of text | URL text | |||||||||||
| TINYTEXT | Possible truncation of text | URL text | ||||||||||||
| TEXT | URL text | |||||||||||||
| MEDIUMTEXT | URL text | |||||||||||||
| LONGTEXT | URL text | |||||||||||||
| TINYBLOB | Possible truncation of data | |||||||||||||
| BLOB | Possible truncation of data | |||||||||||||
| MEDIUMBLOB | Possible truncation of data | |||||||||||||
| LONGBLOB | ||||||||||||||
| ENUM | ||||||||||||||
| TINYINT | Requires "unsigned" | From -128 to 127 | From -128 to 127 | |||||||||||
| SMALLINT | From -32768 to 32767 | From -32768 to 32767 | ||||||||||||
| MEDIUMINT | From -8388608 to 8388607 | From -8388608 to 8388607 | ||||||||||||
| INT | ||||||||||||||
| BIGINT | ||||||||||||||
| FLOAT | Possible truncation of data | Possible loss of precision | ||||||||||||
| DOUBLE | Possible loss of precision | |||||||||||||
| DECIMAL | Possible truncation of data | Possible truncation of data | ||||||||||||
| DATE | Possible truncation of data | |||||||||||||
| DATETIME | ||||||||||||||
| TIMESTAMP |