On 2011-04-30, at 13:36, Jos Groot Lipman wrote: > The rounding problem is documented in the FAQ: > http://www.sqlite.org/faq.html#q16
That reference does not address the issue of the four rounding modes of the Intel FPUs. SQLite being a library rather than a process, does SQLite control the FPU rounding mode or does it rely on the calling thread's FPU rounding mode? This is very important to anyone intending to use the REAL datatype for a financial transaction database. They would be well advised to get local government approval for the system design because not all countries may yet have relaxed their taxation laws that previously insisted on a CURRENCY datatype which uses "round half to even" aka "Bankers' Rounding". <http://en.wikipedia.org/wiki/IEEE_754-2008#Rounding_algorithms> _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users