On Tue, Oct 13, 2009 at 2:01 AM, Robert Simpson <[email protected]> wrote: > I'm pretty sure I do store them as strings -- SQLite doesn't have a > "decimal" datatype, and "double" doesn't cut the precision mustard for > emulating "decimal".
Yes, but I believe the Decimals-as-text will only work if the column is declared as TEXT rather than as NUMERIC. If it is NUMERIC, then the Decimals will be end up being stored as REALs. You can verify this by doing a "select typeof(MyField)" SQL statement. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
