This topic describes the numeric data types supported by PolarDB-X 1.0.
The numeric data types can be classified into two categories by precision:
- Exact numeric data types
- Integer data types: TINYINT, SAMLLINT, MEDIUMINT, INTEGER, and BIGINT
- Fixed-point data types: DECIMAL and NUMERIC
- Approximate numeric data types: FLOAT, REAL, and DOUBLE PRECISION
The supported data types are consistent with those of MySQL. For more information, see Numeric data types in the Reference Manual of MySQL.