Daniel Kasak wrote:
> Chris Ripley wrote:
>> What's a good (or best) field type for money or
>> currency data. Mysql doesn't have a MONEY type for
>> structure, so what would I have the best luck with?
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."
Freelance web developer