On Sun, Mar 25, 2012 at 02:03:44PM -0400, Francis J. Monari, Esquire scratched on the wall: > All, > > Not to sound critical, but to be clear: using SQLite for IEEE > floating point will result in data "loss' unless precautions are > taken.
Define "loss". SQLite, in general, is dependent on the underlying hardware for floating point calculations. These calculations are done within the limitations of the given hardware. Most modern hardware is IEEE 754 compliant, but some mobile platforms are not fully compliant. The SQLite application code takes great care in converting between strings and IEEE 754 values so that no precision or accuracy is lost. What other types of loss are of concern? -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable." -- Angela Johnson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
