On Sun, Apr 13, 2008 at 06:13:04PM +0200, Aladdin Lampé wrote: > Maybe I could also implement my own floating point format, based for > instance on an int64 and a way to tell where the decimal point is. But in > this case I would need to reimplement addition, division, etc. to deal > with the position of the decimal point, and this may have a negative > impact on performance and a storage overhead.
Why not just express all money values in terms of the smallest division of the currency? For example, for dollars, use cents, for pounds use pennies. Sqlite has up to 8 byte integers which would allow for all reasonable values. -- Two hands working can do more than a thousand clasped in prayer _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
