[SOLVED] Unsigned TinyInt goes from 0-255 but

[jordanwb]

Where does the three come in? For example in phpmyadmin, if I create a field with an unsigned TinyInt, its length defaults to three. Unsigned TinyInt goes from 0-255. Any number in that range takes up 8 bits. So where does the Length come into play?

[Barand]

255 is three digits

[jordanwb]

Yeah but if I put in 256 (which requires 9 bits), I get this warning:

 

Warning: #1264 Out of range value adjusted for column 'fgn' at row 1

 

and goes down to 255

[Barand]

As you stated, max value for unsigned tinyint is 255.

 

http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html

 

[jordanwb]

Yes but where does the 3 come in?

[Barand]

255 is three digits

 

If you don't believe me, count them yourself

 

2...5...5

[jordanwb]

So an unsigned TinyInt3 means that the maximum value is any value that can fit into 8 bits and is at most 3 digits long.

[fenway]

So an unsigned TinyInt3 means that the maximum value is any value that can fit into 8 bits and is at most 3 digits long.

Ignore the 3, it's meaningless.  it's dispaly width.

[jordanwb]

Ok.