title: How to insert value for bit column of mysql
body: <p>I want to insert the value into a bit type column in MySQL. But I am getting a data truncation error.</p>
  
  <pre><code>CREATE TABLE `BITTESTTABLE` (
    `db_field` varchar(50) NOT NULL,
     `is_editable` bit(1) NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=latin1
  </code></pre>
  
  <p>If I am inserting a row with </p>
  
  <p><code>INSERT INTO BITTESTTABLE values('XYZ','0')</code></p>
  
  <p>I am getting </p>
  
  <blockquote>
    <p>Data too long for column 'is_editable' at row 1</p>
  </blockquote>
  
  <p>So how do I insert the data for bit type column?</p>