On Mar 22, 2011, at 9:12 AM, LacaK wrote: >> You still don't say what you're planning on doing with these number...just >> displaying them? > > Yes may be ... > I am working on modification of database component for accessing SQLite3 > databases for FreePascal project. > We map declared column's types to native freepascal internal field types. > So DECIMAL and NUMERIC is mapped to TFmtBCDFieldType (which is able to hold > up to 64 digits) > We read column value using sqlite3_column_text and then convert string > representation into TBCD (which is internal structure for "arbitrary" > precision numbers) > But problem arrives when we want write back values. > We use sqlite3_bind_text and as I wrote a this point we loose precision > (because SQLite3 forces conversion to floating point values).
Laco If you already have an arbitrary precision number, just encode it to text, save it in sqlite and then decode on the way out. Tom _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
