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
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to