On 9 Dec 2009, at 6:26pm, Brice Lambi wrote: > I have a table with a DOUBLE column
No you don't. SQLite does not have a DOUBLE type: http://www.sqlite.org/datatype3.html Define those columns as REAL instead. > ... > INSERT INTO "location" VALUES(44.04889722,-96.06321667,577.2912); You will not be able to get that precision out. In most standard GPS applications this won't matter: SINGLE is more precise than a normal GPS fix. However, if you really want the extra precision you'll have to store your numbers as text. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
