Re: [sqlite] decimal precision with DOUBLE columns

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

[sqlite] decimal precision with DOUBLE columns

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 ...