From: Peter Brawley
Date: September 26 2005 11:30pm
Subject: Re: money fields
List-Archive: http://lists.mysql.com/mysql/189593
Message-Id: <43388485.6000407@earthlink.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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