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