cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Aristedes Maniatis <...@ish.com.au>
Subject Re: Question re: data types
Date Thu, 12 Mar 2009 22:37:13 GMT

On 13/03/2009, at 2:55 AM, Chad Smith wrote:

> I guess my question then, is what is the best way to handle money  
> values on the db type and the java type?


BigDecimal in Java and DECIMAL in the database. Floating point numbers  
are evil with respect to money since they are only approximations of  
decimal numbers: I'm sure your tax office would appreciate that note  
on your return stating 'all numbers are approximations only' :-)

Ari Maniatis


-------------------------->
ish
http://www.ish.com.au
Level 1, 30 Wilson Street Newtown 2042 Australia
phone +61 2 9550 5001   fax +61 2 9550 4001
GPG fingerprint CBFB 84B4 738D 4E87 5E5C  5EFA EF6A 7D2E 3E49 102A



Mime
View raw message