title: How to get MySQL command line tool to show booleans stored as BIT sensibly by default
body: <p>I got a problem with selecting boolean types stored as BIT with MySQL. I know that I can get bit values shown in a sensible with with custom queries like with <a href="https://stackoverflow.com/questions/6260730/how-can-convert-bool-to-int-in-mysql" title="CAST">SELECT CAST(1=1 AS SIGNED INTEGER)</a> or with SELECT BOOLFIELD + 0 ...</p>
  
  <p>However, is there any way to get our booleans shown in a sensible way with command line client with queries like SELECT * FROM TABLE ?</p>
  
  <p>UPDATE : At the moment I see only space in the results Example:</p>
  
  <pre><code>mysql&gt; SELECT distinct foo, foo + 0 from table
  +------+-------+
  | foo  | foo_0 |
  +------+-------+
  |      |     0 |  &lt;-- Only space
  |     |     1 |   &lt;-- Space, one space less
  +------+-------+
  </code></pre>
  
  <p>With some googling, I found some (maybe related) bugs from MySQL bug DB (<a href="http://bugs.mysql.com/bug.php?id=28422" rel="noreferrer">http://bugs.mysql.com/bug.php?id=28422</a>, <a href="http://bugs.mysql.com/bug.php?id=43670" rel="noreferrer">http://bugs.mysql.com/bug.php?id=43670</a>) but not answer or fix?</p>