title: MySQL always returning BIT values as blank
body: <p>From my create table script, I've defined the hasMultipleColors field as a BIT:</p>
  
  <pre><code>hasMultipleColors BIT NOT NULL,
  </code></pre>
  
  <p>When running an INSERT, there are no warnings thrown for this or the other BIT fields, but selecting the rows shows that all BIT values are blank.</p>
  
  <p>Manually trying to UPDATE these records from the command line gives odd effect - shows that the record was match and changed (if appropriate), but still always shows blank.</p>
  
  <p>Server version: 5.5.24-0ubuntu0.12.04.1 (Ubuntu)</p>
  
  <pre><code>mysql&gt; update pumps set hasMultipleColors = 1 where id = 1;
  Query OK, 0 rows affected (0.00 sec)
  Rows matched: 1  Changed: 0  Warnings: 0
  
  mysql&gt; select hasMultipleColors from pumps where id = 1;
  +-------------------+
  | hasMultipleColors |
  +-------------------+
  |                  |
  +-------------------+
  1 row in set (0.00 sec)
  
  mysql&gt; update pumps set hasMultipleColors = b'0' where id = 1;
  Query OK, 1 row affected (0.00 sec)
  Rows matched: 1  Changed: 1  Warnings: 0
  
  mysql&gt; select hasMultipleColors from pumps where id = 1;
  +-------------------+
  | hasMultipleColors |
  +-------------------+
  |                   |
  +-------------------+
  1 row in set (0.00 sec)
  </code></pre>
  
  <p>Any thoughts?</p>