Hi, How point numbers are they stored in sqlite?
In a field with REAL affinity: round(11.578767 / 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. Greetings olivier _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
