title: What is the datatype to store boolean value in MySQL?
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/289727/which-mysql-datatype-to-use-for-storing-boolean-values">Which MySQL Datatype to use for storing boolean values?</a>  </p>
  </blockquote>
  
  
  
  <p>I am a .NET programmer and using MySQL database for the first time in my life.</p>
  
  <p>I wanted to store boolean value, MySQL has <code>BIT</code>, but the .NET conversion of this datatype is <code>UINT64</code>.</p>
  
  <p>There is another datatype <code>TINYINT(1)</code>, whose .NET equivalent is <code>System.Boolean</code> which will serve my purpose. </p>
  
  <p>But why will I use <code>TINYINT(1)</code> (which can store value like 123, 22) instead of <code>BIT</code>, and <strong>it will take more space than <code>BIT</code> also (I guess)</strong>? It may be legal to use it but I dont think it is etical.</p>
  
  <p>Can someone please help and clarify my doubt?</p>