Hi, there's a bug in ToadForMysql 6.0.1: If you have an tinyint-field which ist defined with "tinyint(1)" Toad shows an checkbox-field. That's wrong. Quote from mysql.com:
The display width does not constrain the range of values that can be stored in the column, nor the number of digits that will be displayed for values having a width exceeding that specified for the column.
Whenused in conjunction with the optional extension attribute ZEROFILL, thedefault padding of spaces is replaced with zeros. For example, for a column declared as INT(5) ZEROFILL, a value of 4 is retrieved as 00004. Note that if you store larger values than the display width in an integer column, you may experience problems when MySQL generates temporary tables for some complicated joins, because in these cases MySQL trusts that the data did fit into the original column width.
Edit: You can have (for example) the number 6 in a tinyint(1)-field, but this number wouldn't be displayed because the field displays itself as a checkbox in Toad.