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.