On 8 May 2014, at 3:06pm, Werner Kleiner <sqliteh...@web.de> 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 ?
Numeric values in numeric fields are not really stored as text, they're stored as binary representations. There's no real decimal point stored unless the column was declared as TEXT. Generally speaking, if all the values in a column are expected to be integers (or missing), declare the column as INTEGER. If the values are continuous measurements, declare the column as REAL. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users