Hello Neil,
On 5/22/2013 1:05 PM, Neil Tompkins wrote:
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 ?
This is exactly the same behavior that MySQL has had for over a decade.
Nothing has been added or removed since release 4.1.0 (2003-04-03)
http://dev.mysql.com/doc/refman/4.1/en/numeric-type-overview.html
http://dev.mysql.com/doc/refman/4.1/en/news-4-1-x.html
Also, why are you using a pre-release (milestone) version of 5.6 when
the full release (GA) versions of 5.6 are available?
http://dev.mysql.com/doc/relnotes/mysql/5.6/en/
Regards,
--
Shawn Green
MySQL Principal Technical Support Engineer
Oracle USA, Inc. - Hardware and Software, Engineered to Work Together.
Office: Blountville, TN
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
