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
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
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
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?
4 matches
Mail list logo