Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

10
  • 249
    Anyone who is reading the old answers to this question needs to understand that MySQL added a bit datatype in version 5. Use that information as you may. dev.mysql.com/doc/refman/5.0/en/bit-type.html Commented Feb 29, 2012 at 14:51
  • 3
    Question related to Alternative to lots of booleans in MySQL? Commented Jul 25, 2012 at 18:26
  • 8
    for the current version of MYSQL Boolean type is available- dev.mysql.com/doc/refman/5.5/en/numeric-type-overview.html check this. according to that value zero considered as false Commented Aug 29, 2012 at 8:51
  • 9
    bit(1)'s a bit** to import in Excel. Switching to tinyint(1) works. Commented Feb 18, 2014 at 13:24
  • 8
    now we have boolean after 5 years Commented Mar 14, 2014 at 9:54