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 yes, is there a way to retrieve the same floating point stored (23.123567) without having to save the data as TEXT. Cheers Folabi -- View this message in context: http://www.nabble.com/storing-floating-point-values-in-field-tf4051483.html#a11508159 Sent from the SQLite mailing list archive at Nabble.com. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------