On 2 Jan 2010, at 9:54am, Bert Nelsen wrote: > I am trying to save values like 19.000.000.000 to my database but I haven't > found the appropriate column type yet. Can anybody help please. > I am using the dhRichClient command object, but even Int64 isn't large > enough.
There are only five datatypes in SQLite3, and one of them doesn't store a value: <http://www.sqlite.org/datatype3.html> If you need values that large you can't use INTEGER. If you need precision to the 1 then you can't use REAL. So you can store those only as TEXT or BLOB. Would TEXT work for you ? Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
