Re: [sqlite] storing floating point values in field

2007-07-10 Thread John Stanton
From: Chris Wedgwood <[EMAIL PROTECTED]> CC: sqlite-users@sqlite.org Subject: Re: [sqlite] storing floating point values in field Date: Mon, 9 Jul 2007 13:49:17 -0700 On Mon, Jul 09, 2007 at 12:20:48PM -0700, folabi wrote: However, when i wanted to retrieve th

Re: [sqlite] storing floating point values in field

2007-07-10 Thread folabi
to run on the windows platform? Thanks again Folabi From: Chris Wedgwood <[EMAIL PROTECTED]> CC: sqlite-users@sqlite.org Subject: Re: [sqlite] storing floating point values in field Date: Mon, 9 Jul 2

Re: [sqlite] storing floating point values in field

2007-07-09 Thread Mohd Radzi Ibrahim
ject: [sqlite] storing floating point values in field Hi, I stored a floating point number in a sqlite field with datatype REAL. However, when i wanted to retrieve the data, sqlite returned a rounded value back. ie. double val = 23.123567 stored as REAL sqlite returns 23.1236 Cou

[sqlite] storing floating point values in field

2007-07-09 Thread folabi
Hi, I stored a floating point number in a sqlite field with datatype REAL. However, when i wanted to retrieve the data, sqlite returned a rounded value back. ie. double val = 23.123567 stored as REAL sqlite returns 23.1236 Could someone pls confirm if this is consistent behaviour in sqlite?