Re: [sqlite] storing floating point values in field

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

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

I've run SQLite3 inWindows, it's store up it surely did not truncate the decimal point - up to 15 significant digits... regards, Radzi. - Original Message - From: "folabi" <[EMAIL PROTECTED]> To: Sent: Tuesday, July 10, 2007 3:20 AM Subject: [sqlite] storin

[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 Could someone pls confirm if this is consistent behaviour in sqlite? If