Tinkering with MySQL and have a question.

If the unsigned range of TINYINT is -128 to 127, should the display width be TINYINT(3) or TINYINT(4)?

Basically, I'm trying to find out if the minus sign needs to be accounted for.

Any advice from DB experts would be welcomed!

Four things have been revealed:

1) I got it wrong in the above post. The SIGNED range of TINYINT is -128 to 127.

2) SIGNED (or not specified) the default width is (4).
The minus sign does need to be accounted for.

3) UNSIGNED the range is 0 to 255.
As only 3 digits are used the default width is (3).

4) In PHPMyAdmin, if you leave the width field empty for numeric data, it enters the MySQL default for the data type automatically.

Doh!