[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(11.578767 / 2 , 4) is displayed 5.7894 in SQLite/Navicat :-), but 5,78939997 in the cursor of my development language when I get it to sqlite. Internally, SQLite works with 5.7894

Re: [sqlite] How point numbers are they stored in sqlite?

On Tue, Apr 17, 2012 at 5:12 AM, Paxdo Presse pa...@mac.com wrote: 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,78939997 in the cursor of my development language when I

Re: [sqlite] How point numbers are they stored in sqlite?

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

Re: [sqlite] How point numbers are they stored in sqlite?

On 17 avr. 2012, at 11:35, Richard Hipp wrote: On Tue, Apr 17, 2012 at 5:12 AM, Paxdo Presse pa...@mac.commailto:pa...@mac.com wrote: 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

Re: [sqlite] How point numbers are they stored in sqlite?

ok, thank you all! Le 17 avr. 2012 à 11:35, Richard Hipp a écrit : Key point: Floating point numbers are approximations. This is an inherent property of IEEE floating point numbers, not a limitation of SQLite. If you need an exact answer, use integers. -- D. Richard Hipp