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 [1] for more information.
DECIMAL would suit your needs better -- from [2]: "The DECIMAL and
NUME
Chris,
>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?
Someone suggested double, but with big sums that can give you rounding
errors. Try DECIMAL.
PB
--
No virus found in this outg
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?
double
No way. You should *never* use floating-point types for currency if you
care about precisi
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?
double
--
Daniel Kasak
IT Developer
NUS Consulting Group
Level 5, 77 Pacific Highway
North Sydney, NSW, Australia 2060
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?
Thanks,
Chris
Chris Ripley
[EMAIL PROTECTED]
KOZE Radio
__
Yahoo! Mail - PC Magazine Editors'
