Hi, Like the link states "For clarity: a TINYINT(1) datatype does NOT ENFORCE a boolean value data entry. For instance, it's still possible to insert a value of "2" (any integer up to the TINYINT max value). I personally don't see the added value of a 'BOOLEAN' synonym type which infact behaves unlike a boolean should."
Has BOOL, BOOLEAN been taken out of MySQL 5.6 ? On Wed, May 22, 2013 at 6:01 PM, Ian Simpson <i...@it.myjobgroup.co.uk>wrote: > BOOLEAN is a synonym for TINYINT(1) in MySQL: > > http://dev.mysql.com/doc/refman/5.6/en/numeric-type-overview.html > > > On 22 May 2013 17:55, Neil Tompkins <neil.tompk...@googlemail.com> wrote: > >> Hi, >> >> I've just created some tables that I designed using the MySQL Workbench >> Model. However, the database type BOOLEAN which was in my models has been >> converted to TINYINT(1); I'm currently running MySQL Version 5.6.2-m5 on >> Windows 2008 server. >> >> Any ideas why this has been removed ? >> >> Neil >> > >