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