title: MySQL table: BIT(1) not null default b'1', however, always default to '0'
body: <p>This is how I created the table:</p>
  
  <pre><code>CREATE TABLE `item_spa_cust` (
      `id` INT(10) NOT NULL AUTO_INCREMENT,
      `spa_id` INT(10) NULL DEFAULT NULL,
      `type` VARCHAR(20) NOT NULL COLLATE 'latin1_swedish_ci',
      `is_valid` BIT(1) NOT NULL DEFAULT b'1',
      `company_name` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
      `custno` VARCHAR(6) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci',
      PRIMARY KEY (`id`),
      INDEX `FK_item_spa_cust_item_spa` (`spa_id`),
      CONSTRAINT `FK_item_spa_cust_item_spa` FOREIGN KEY (`spa_id`) REFERENCES `item_spa` (`id`)) 
  ;
  </code></pre>
  
  <p>I was expecting the <code>is_valid</code> field to default to '1' as I set it, however, it's always defaulting to '0'.</p>
  
  <p>I'm very confused about this, please help.</p>