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