From: Date: December 3 2003 8:03am
Subject: Money data type in MySQL?
List-Archive: http://lists.mysql.com/mysql/154920
Message-Id: <3FCD8AAE.8030806@zara.6.isreserved.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

What do people recommend for storing money amounts? I've seen people use 
NUMERIC(18,3) and other use NUMERIC(18,4). Which one is more appropriate 
and why? This is considering various existing currencies, some having 
low rates (like IDR, in which you can have large amount up to hundreds 
of trillions) and some high rates (like USD, in which you can have small 
amount like 0.1 cent). Are there places/industries which involve values 
lower than 0.1 cent?

And what about 'factor' field in currency conversion table? Should I use 
FLOAT, or DOUBLE (do we need 15-16 digit precision?) or NUMERIC (exact 
numbers). The factor should range between 1E-3 (e.g. converting IDR to 
USD) to 1E4 (e.g. converting IDR to pounds/euros).

-- 
dave