Cacher is the code snippet organizer for pro developers

mysql> create table foo ( p bit(32) default 0 );
Query OK, 0 rows affected (0.20 sec)

mysql> show create table foo;
+-------+----------------------------------------------------------------------------------------+
| Table | Create Table                                                                           |
+-------+----------------------------------------------------------------------------------------+
| foo   | CREATE TABLE `foo` (
  `p` bit(32) DEFAULT b'0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 | 
+-------+----------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql> create table bar ( p bit(32) default '0' );
Query OK, 0 rows affected (0.08 sec)

mysql> show create table bar;
+-------+---------------------------------------------------------------------------------------------+
| Table | Create Table                                                                                |
+-------+---------------------------------------------------------------------------------------------+
| bar   | CREATE TABLE `bar` (
  `p` bit(32) DEFAULT b'110000'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 | 
+-------+---------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)