PolarDB:Numeric data types

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, SMALLINT, MEDIUMINT, INTEGER, and BIGINT
  • Fixed-point data types: DECIMAL and NUMERIC
• Approximate numeric data types: FLOAT, REAL, DOUBLE 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.