If you already have an arbitrary precision number, just encode it to
text, save it in sqlite and then decode on the way out.
Yes it is possible, but such values (and databases) will not be readable
by other database connectors
(like for example in PHP etc.)
Problem will be solved if SQLite will store such values as text ... so
will behave like this:
1. is supplied value in TEXT (sqlite3_bind_text)
2. if yes then try convert this text value into INTEGER or REAL
3. convert back to text and compare with original value
4. if equal then store it as INTEGER or REAL, if not then store it as is
as supplied in (1).
Laco.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
