Datatypes: MySQL Compared to Access 2000 and SQL Server 7
Table 1.1 lists data types (column types) for MySQL as they are compared to Access 2000 and SQL Server 7. Note that some types have no corresponding type; those entries are blank.
If you are converting a database or wondering whether your data will fit into one of MySQL’s types, Table 1.1 might be of help. Additionally, although two data (or column) types might have the same name, their storage requirements might be different.
Datatype | Storage in Bytes | Access2000 | SQL Server 7 | Notes |
---|---|---|---|---|
tinyint | 1 | byte | tinyint | |
smallint | 2 | integer | smallint | |
mediumint | 3 | |||
int | 4 | Long Integer | int or integer | |
bigint | 8 | |||
float | 4 | single ... |
Get MySQL Building User Interfaces now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.