List:General Discussion« Previous MessageNext Message »
From:Peter Brawley Date:September 26 2005 11:30pm
Subject:Re: money fields
View as plain text  
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 outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.11.6/111 - Release Date: 9/23/2005

Thread
money fieldsChris Ripley27 Sep
  • Re: money fieldsDaniel Kasak27 Sep
    • Re: money fieldsJasper Bryant-Greene27 Sep
      • Re: money fieldsDaniel Kasak27 Sep
  • Re: money fieldsPeter Brawley27 Sep