[FIXED] What is the maximum value of unsigned DECIMAL(M, D) column?

Issue

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?

Solution

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

Answered By - blabla_bingo

Answer Checked By - Cary Denson (PHPFixing Admin)