List:General Discussion« Previous MessageNext Message »
From:Neil Tompkins Date:May 22 2013 5:05pm
Subject:Re: Version 5.6.2-m5 Boolean Datatype
View as plain text  
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 <ian@stripped>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.tompkins@stripped> 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
>>
>
>

Thread
Version 5.6.2-m5 Boolean DatatypeNeil Tompkins22 May
  • Re: Version 5.6.2-m5 Boolean DatatypeHartmut Holzgraefe22 May
Re: Version 5.6.2-m5 Boolean DatatypeNeil Tompkins22 May
  • Re: Version 5.6.2-m5 Boolean Datatypeshawn green22 May
    • Re: Version 5.6.2-m5 Boolean DatatypeNeil Tompkins22 May
      • Re: Version 5.6.2-m5 Boolean DatatypeDarryle Steplight22 May
Re: Version 5.6.2-m5 Boolean DatatypeWm Mussatto22 May
  • RE: Version 5.6.2-m5 Boolean DatatypeRick James22 May
    • RE: Version 5.6.2-m5 Boolean Datatypehsv23 May