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 -- View this message in context: http://www.nabble.com/storing-floating-point-values-in-field-tf4051483.html#a11516149 Sent from the SQLite mailing list archive at Nabble.com. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
