title: Insert boolean value into sqlite table
body: <p>I created a table <code>MYTABLE</code> </p>
  
  <pre><code>CREATE TABLE "MYTABLE" (
         "surname" VARCHAR,
         "name" VARCHAR,
         "id" INTEGER PRIMARY KEY  NOT NULL ,
         "flag" BOOL);
  </code></pre>
  
  <p>when I insert a record with:</p>
  
  <pre><code>INSERT INTO "MYTABLE" VALUES ("Super","Mario","94", true);
  </code></pre>
  
  <p>I get an error message, that <code>no such column: true</code>. If I use this:</p>
  
  <pre><code>INSERT INTO "MYTABLE" VALUES ("Super","Mario","94", "true");
  </code></pre>
  
  <p>I don't get any error, but when i read that record with <code>rs.getBoolean("flag")</code> I get false. </p>
  
  <p>Finally, i tried this</p>
  
  <pre><code>INSERT INTO "MYTABLE" VALUES ("Super","Mario","94", 1); 
  </code></pre>
  
  <p>the <code>rs.getBoolean("flag")</code> returns <code>true</code>. So the lesson here is that the boolean values in Sqlite are inserted with 0/1 ?</p>