# sqldatatypes – MySQL ; Best data type for large numbers

## sqldatatypes – MySQL ; Best data type for large numbers

MySQL Integer Types (Exact Value):

Fixed-Point Types (Exact Value) – DECIMAL, NUMERIC:

In standard SQL, the syntax DECIMAL(M) is equivalent to DECIMAL(M,0).

Similarly, the syntax DECIMAL is equivalent to DECIMAL(M,0), where the

implementation is permitted to decide the value of M. MySQL supports

both of these variant forms of DECIMAL syntax. The default value of M

is 10.If the scale is 0, DECIMAL values contain no decimal point or

fractional part.The maximum number of digits for DECIMAL is 65, but the actual range

for a given DECIMAL column can be constrained by the precision or

scale for a given column. When such a column is assigned a value with

more digits following the decimal point than are permitted by the

specified scale, the value is converted to that scale. (The precise

behavior is operating system-specific, but generally the effect is

truncation to the permissible number of digits.)