Think I found what it is: Wrong data type when importing <code> PRAGMA table_info(zip); cid;name;type;notnull;dflt_value;pk 0;ZIP;TEXT;0;;0 1;CITY;TEXT;0;;0 2;LATITUDE;TEXT;0;;0 3;LONGITUDE;TEXT;0;;0 PRAGMA table_info(main); cid;name;type;notnull;dflt_value;pk 0;ZIP;;0;;0 1;TRANS;;0;;0 </code>