On Tue, Oct 13, 2009 at 11:07 PM, Fred Williams <fwilliam...@gmail.com> wrote:

> The best way I have found to manage decimal (Business math) with most all
> the databases is to use integers and multiply and divide by the decimal
> offset (i.e. 10, 100, 1000) for presentation purposes,  doing my own
> "bankers rounding"  in code.  Big hassle, but transports well.

I think you are right.  Using integers is probably the best way. It is
the approach I am going to take. I am using a Object Relational Mapper
called LightSpeed, and it turns out I can put the scaling in the
getters and setters of my objects.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to