I can say there's no string round-trips with fairly high confidence and I am using _bind_double and _column_double.
I can also confirm NaNs are a special case, as I've had to write code to store those as a BLOB. On Thu Jan 29 2015 at 9:57:14 AM Igor Tandetnik <i...@tandetnik.org> wrote: > On 1/28/2015 5:47 PM, Donald Shepherd wrote: > > This is a bit of a speculative question related to a problem I'm having - > > are there legal values of a C++ double that would get truncated when > > written into and read from an SQLite database? > > Written into and read from how, exactly? Do they, say, round-trip > through a string representation at any point? > > I'm pretty sure that, if you put a value into a column with correct > affinity using sqlite3_bind_double, you'd get the exact same value out > using sqlite3_column_double (signalling NaN possibly excepted). > -- > Igor Tandetnik > > _______________________________________________ > sqlite-users mailing list > email@example.com > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list firstname.lastname@example.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users