This topic describes the numeric data types supported by PolarDB-X.

The numeric data types in PolarDB-X can be classified into two categories based on precision:

  • Exact numeric data types include:
    • Integer data types: TINYINT, SAMLLINT, MEDIUMINT, INTEGER, and BIGINT
    • Fixed-point data types: DECIMAL and NUMERIC
  • Approximate numeric data types: FLOAT, REAL, DOUBLE, and PRECISION

The data types that are available in MySQL are also supported by DRDS. For more information, see Numeric data types in the Reference Manual of MySQL.