MySQL Building User Interfaces

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.

Table 1.1. Datatype Conversion Matrix, MySQL, Access2000, and SQL Server 7

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 ...