> From: Paxdo Presse <pa...@mac.com> > To: General Discussion of SQLite Database <sqlite-users@sqlite.org> > Date: Tue, 17 Apr 2012 11:12:45 +0200 > Subject: [sqlite] How point numbers are they stored in sqlite? > >Hi, > >How point numbers are they stored in sqlite? > >In a field with REAL affinity: > >round(11578767 / 2 , 4) is displayed "5.7894" in SQLite/Navicat :-), >but "5,7893999999999997" in the cursor of my development language >when I get it to sqlite. > >Internally, SQLite works with 5.7894 or 5,7893999999999997? > >This is important because it can cause problems rounding. >ditto for the calculations on decimal currency. >
I believe that for accounting purposes, basides SQLite, the best solution is to use an adequate library such as the IBM decNumber package. HTH. Adolfo J. Millan Zator Systems. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
