title: mysql converting bit to char not working
body: <p>I was trying to feed a result of a query as a parameter for another query and all was working fine except this field that has a datatype of bit. so i tried to convert the value of the field using convert() and cast() but it seems to be not working as its returning this wierd symbol of a small rectange which hava three 0's and a 1. so can anyone tell me why this is happening and how to fix it , here is my query</p>
  
  <pre><code>select CONVERT(isMale , char(5)) from person;
  </code></pre>
  
  <p>and the thing is it gives me the correct answer when i dont use the convert but since am giving this result to another query as a parameter it  causing me the problem.  </p>