title: How to correct 'datatype mismatch' error while importing the csv file into sqlite table?
body: <p>I am trying to import the following data into the sqlite3 table via <em>nodes_corrected.csv</em> file:</p>
  
  <blockquote>
    <p>id,lat,lon,user,uid,version,changeset,timestamp
    26529519,12.9728616,77.6199745,Nagesh_Blr,1765920,34,26587371,2014-11-06
    07:56:32.000</p>
  </blockquote>
  
  <p>I have a schema:</p>
  
  <pre><code>CREATE TABLE nodes (
      id INTEGER PRIMARY KEY NOT NULL,
      lat REAL,
      lon REAL,
      user TEXT,
      uid INTEGER,
      version INTEGER,
      changeset INTEGER,
      timestamp TEXT );
  </code></pre>
  
  <p>After I use the following code on the terminal:</p>
  
  <pre><code>.mode csv
  .import nodes_corrected nodes
  </code></pre>
  
  <p>I get the following error on terminal:</p>
  
  <blockquote>
    <p>nodes_corrected:1: INSERT failed: datatype mismatch</p>
  </blockquote>
  
  <p>Could somebody please help, I am stuck on it for a day?</p>