You seem to be looking at the output of the floating point to ASCII
function in the Sqlite command line shell program, not the floating
point number itself.
folabi wrote:
Thanks for the feedback Chris
I ran the sqlite3.exe on the command line and got the same results as you
did.
I consume the sqlite library as a .lib file which i compiled from the source
code.
Do you know of any caveats i should be aware of when compiling the sqlite
librarry as a static lib 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 2007 13:49:17 -0700
On Mon, Jul 09, 2007 at 12:20:48PM -0700, folabi wrote:
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
sqlite> create table t1 ( c1 int, c2 real, c3 );
sqlite> insert into t1 values(23.123567,23.123567,23.123567);
sqlite> select * from t1;
23.123567|23.123567|23.123567
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
