title: Updating mysql bit datatype using codeigniter active record
body: <p>I have a table with one columns datatype as BIT(1) . I am using active record of codeigniter for performing queries. But the setting of bit is not working. Does anybody has idea about how to do it? Or I have to get back to normal query?</p>
  
  <p>Following is the code snippet:</p>
  
  <pre><code>function itemUpdate($options=array()) {
  if(isset($options['isAvailable']))
     $itemDB-&gt;set('isAvailable',$options['isAvailable']);
     $itemDB-&gt;where('id', $options['id']);
     $itemDB-&gt;update('Item');
  }
  </code></pre>