5.5. Numeric Types

The ISO SQL:2003 standard defines two numeric types. Each numeric type has a few different data types. The standard numeric types and their associated keywords are:

• Exact numeric type:

  • NUMERIC(g,f)

  • DECIMAL(g,f) can be abbreviated as DEC

  • SMALLINT

  • INTEGER can be abbreviated as INT

  • BIGINT

  Table 5.2. Summary of MySQL Binary Data Types

  Data Type Name	SQL Standard?	Fixed/Variable Length	Range	Size	Attributes
  BINARY	No	Fixed	Length of 0–255 bytes	M bytes	DEFAULTNOT NULLNULL
  VARBINARY	No	Variable	Length of 0–65,532 bytes	L*x + 1 if L<255L*x + 2 if L>255	DEFAULTNOT NULLNULL
  TINYBLOB	No	Variable	Max length of 255 bytes	L + 1 bytes 1 byte stores length	NOT NULLNULL
  BLOB	No	Variable	Max length of 65,535 bytes (64 Kb)	L + 2 bytes 2 bytes store length	NOT NULLNULL
  MEDIUMBLOB	No	Variable	Max length of 16,777,215 bytes (16 Mb)	L + 3 bytes 3 bytes store length	NOT NULLNULL
  LONGBLOB	No	Variable	Max length of 4,294,967,295 bytes (4 Gb)	L + 4 bytes 2 bytes store length	NOT NULLNULL

  
  

• Approximate numeric type:

  • FLOAT(p)

  • REAL

  • DOUBLE PRECISION