title: How to Insert BOOL Value to MySQL Database
body: <p>I am trying to insert values into a <code>BOOL</code> data type in MySQL (v 5.5.20) using the following script:</p>
  
  <pre><code>CREATE DATABASE DBTest;
  USE DBTest;
  DROP TABLE IF EXISTS first;
  CREATE TABLE first (id INT AUTO_INCREMENT NOT NULL PRIMARY KEY , name VARCHAR(30) ,sale  BOOL,); 
  INSERT INTO first VALUES ("", "G22","TRUE");
  INSERT INTO first VALUES ("", "G23","FALSE");
  </code></pre>
  
  <p>But the  <code>INSERT</code> statement just inserts <code>0</code> (Zero) to the boolean column for both <code>TRUE</code> and <code>FALSE</code> options! Can you please let me know why this is happening?</p>