title: Rails 3 SQLite3 Boolean false
body: <p>I'm trying to insert a false boolean value in a SQLite3 table but it always inserts a true value.</p>
  
  <p>Here's my migration:</p>
  
  <pre><code>class CreateUsers &lt; ActiveRecord::Migration
    def self.up
      create_table :users do |t|
        t.column :name, :string
        t.column :active, :boolean, :default =&gt; false, :null =&gt; false
      end
    end
  
    def self.down
      drop_table :resources
    end
  end
  </code></pre>
  
  <p>When I try to insert using rails it produces the following SQL:</p>
  
  <pre><code>INSERT INTO "users" ("name", "active") VALUES ('test', 'f')
  </code></pre>
  
  <p>SQLite treats 'f' as true so it inserts true into my database. The query I want it to generate is:</p>
  
  <pre><code>INSERT INTO "users" ("name", "active") VALUES ('test', false)
  </code></pre>
  
  <p>What am I doing wrong?</p>
  
  <p>rails: 3.0.7</p>
  
  <p>sqlite3 gem: 1.3.3</p>