On 30 Nov 2009, at 2:05pm, Michael Lippautz wrote: > 47.824669 / 47.824669167
Same number. If you need better precision than that, declare the column type as TEXT and bind your data as text. But since you're using GPS coordinates I can tell you it's not necessary. That seventh digit in a GPS coordinate gives you more precision than a GPS device can actually deliver. No consumer GPS device is going to quote you 47.8246690 in one place and 47.8246691 to mean a different place. So you don't need to worry about your rounding error. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
