On 2014/05/08 16:06, Werner Kleiner wrote:
Hmm, but would it not be better to store the value 50000 as
50000.0 , which would be correct for the decimal point
instead of
5000.0 ?
I think the other replies to your post missed the fact that the value is different by an order of magnitude. That's not an SQLite
problem, you are making a mistake somewhere else.
Try doing the insert as INSERT INTO mytable (mycol) VALUES ('50000');
SELECT * FROM mytable;
Replace mycol and mytable with whatever your table's name/column is.
If it does not return 50000.0 or 50000 or '50000' (depending on the type of
"mycol") then SQLite is broken...
(spoiler: SQLite isn't broken).
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
