On 11 Aug 2009, at 10:02pm, Tishchenko, Seva wrote: > Even if I declare this column as TEXT, > SQLite still tries to guess the value type and the output result is > "1.23456789012346E19" as well unless I put it in quotes or add a > non-numeric character.
Well yes, but adding quotes (single quotes) is exactly what makes it a string and not a number. That's what they're for. > Is there a way to store a large number without > loosing it's precision? You're going to end up with either TEXT or a BLOB. How large do you want to be able to go ? Do you need SQLite to be able to use these numbers correctly in indexes (i.e. to correctly order them) ? Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
