Types

[thoand]

Hi I have created a table with a colum like this:

foo TINYINT(2) unsigned

As far as I thought this should store values from 0 - 99
but it can store a value like 244, eg:

insert into tbl (foo) values (244);

Can anyone explain what I've missed?
by the way it si the win32 version og MySQL

thanks in advance,

Thomas Andersen

[Shadeless]

Hi if u go to www.mysql.com u can find some documentation there. It also contains some information about the TINYINT value

Claudio Guidi Colombi: TINYINT[(M)] [UNSIGNED] [ZEROFILL] A very small integer. The signed range is -128 to 127. The unsigned range is 0 to 255 Page 6.2 of manual.

Further info about the TINYINT can be found in the mysql documentation on www.mysql.com

[[deleted]]

In mysql, the number in the brackets is only the 'display' size. Tinyint can alway store what an tinyint can store, -127 to 127 or 0-255, but the (2) indicates that mysql will only print 2 chars of the output. Which 2? nobody knows.

This is possibly the most retarded function in mysql since it was first created.

This 'feature' has driven many people out of their minds when used with timestamp columns. The limitation skips the leftmost chars, which indicate the year. But mysql then procedes to interpret the output from left to right. So the month is interpreted as weeks, hours as days, and seconds as hours, completely messing everything up.

Just leave the brackets off completely when you create a database, they serve no purpose at all in mysql.