I found a DECIMAL(5, 2) column supports a range of -999.99 to 999.99 in 12.22.2 DECIMAL Data Type Characteristics.

When the column is defined as UNSIGNED, what is the maximum value that the column supports? Is it still 999.99?

CodePudding user response：

This probably took less time than your typing the question. Like P.Salmon said, there really should be something more deep behind this.

create table td (d decimal(5,2) unsigned);
insert td values(999.99);
-- Query OK, 1 row affected (0.00 sec)
insert td values(1000);
-- ERROR 1264 (22003): Out of range value for column 'd' at row 1