Learn SQL Database Programming

Numeric data types table comparison

The following table lists the numeric data types available in MySQL and shows whether or not they are available in Oracle, PostgreSQL, and SQL Server.

The size allowances on Oracle, PostgreSQL, and SQL Server may be different even if the data type name is the same.

Numeric data types in MySQL	Also available in
Data Type	SQL Server	PostgreSQL	Oracle
INT	Yes	Use INTEGER instead	Use NUMBER instead
TINYINT	Yes	No	No
SMALLINT	Yes	Yes	No
MEDIUMINT	No	No	No
BIGINT	Yes	Yes	No
FLOAT	Yes	No	Use NUMBER instead
DOUBLE	Use FLOAT instead	Use DOUBLE PRECISION instead	Use NUMBER instead
DECIMAL	Yes	Yes	Use NUMBER instead
BIT	Yes	No	No

The preceding table lists the numeric data types available ...