Numeric Data Types

Numeric data types are used to store numbers.

• INT: Integer data type.Signed range is from -2147483648 to 2147483647. Unsigned range is from 0 to 4294967295. Example: INT, INTEGER, INT(size),INTEGER(size).
• DECIMAL(p, s): Fixed-point number with precision p and scale s.The maximum number for size is 65. The maximum number for d is 30. The default value for size is 10. The default value for d is 0. Example: DECIMAL(10, 2).
• FLOAT: Floating-point number. The number of digits after the decimal point can be specified in the parameter. Example: FLOAT, FLOAT(2), REAL.
• DOUBLE: Double-precision floating-point number. The total number of digits is specified in size. The number of digits after the decimal point is specified in the d parameter. Example: DOUBLE,DOUBLE(10,25).