eternelmangekyosharingan <eternelmangekyosharin...@gmail.com> wrote: > I create the following table: > sqlite> create table t1(a); > sqlite> insert into t1 values(123456789.123456789); > > I ran the following commands: > sqlite> select * from t1; > 123456789.123457 > sqlite> select typeof(a) from t1; > real > > What I expected to get is: > sqlite> select * from t1; > 123456789.123456789 > sqlite> select typeof(a) from t1; > text > > since the conversion of 123456789.123456789 to real induce some loss.
http://www.sqlite.org/datatype3.html For conversions between TEXT and REAL storage classes, SQLite considers the conversion to be lossless and reversible if the first 15 significant decimal digits of the number are preserved. So no, by SQLite's definition, there is no loss. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users