Hi, I'm trying to store a larges number in a SQLite column, something like "12345678901234567890". This number does not exceed 8 bytes capacity, however it gets truncated by SQLite to the form of "1.23456789012346E19". Note that the number has lost 5 digits in precision and got rounded. 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. Is there a way to store a large number without loosing it's precision?
Thank you, Vsevolod _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
