Hello,

I have a table with a DOUBLE column but anytime I select from it I only
get two decimal places.  When I do a dump it will dump the original
value out at the correct precision.  Example:


sqlite> select lat,lon from location limit 10;
44.18|-96.19
44.18|-96.19
44.18|-96.19
44.18|-96.19
...

sqlite> .dump
...
INSERT INTO "location" VALUES(44.04889722,-96.06321667,577.2912);
...

Also when I access this database from python I see the same thing.  How
can I tell it to give me the entire number?

Thanks,
Brice Lambi
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to