Quest is pleased to announce the general release of Toad for MySQL 6.0.1 patchrelease update.Two specific bugs are fixed in this release.
• It was impossible to use the compare & sync functionality.• It was impossible to create the schema objects needed to do debugging.
Get it now at http://www.toadformysql.com/!
But does ZEROFILL affect tinyint(1), which before MySQL 5.0.3 was interpreted as BIT?http://stormysan.com/2011/02/mysql-integer-lengths/
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.Hope you can fix this. Thanks!
Message was edited by: Pascal J.
I have the same problem.I have a field type: tinyint(1) and I see it as a checkbox.how can I see it as numeric field?