Jasper Bryant-Greene wrote:
> No way. You should *never* use floating-point types for currency if
> you care about precision. You'll experience all sorts of weird
> rounding and comparison errors. See  for more information.
> DECIMAL would suit your needs better -- from : "The DECIMAL and
> NUMERIC types [...] are used to store values for which it is important
> to preserve exact precision, for example with monetary data."
>  http://en.wikipedia.org/wiki/Floating_point
>  http://dev.mysql.com/doc/mysql/en/numeric-types.html
Back to the drawing board then. I'm *sure* I saw someone else recommend
that ... many years ago now.
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989