[TriLUG] Money in mysql

[Joseph Mack]

Matt Frye wrote:
> 
> What's the best numeric type in mysql for dealing with money, i.e.
> dollars and cents?  Float, decimal, fixed?  Informed suggestions
> appreciated.

In the old days all money calculations were done in BCD (binary coded decimal)
which was designed for money and was exact for floating point addition/subtraction. 
Does mysql have BCD?

Joe

-- 
Joseph Mack PhD, High Performance Computing & Scientific Visualization
LMIT, Supporting the EPA Research Triangle Park, NC 919-541-0007
Federal Contact - John B. Smith 919-541-1087 - smith.johnb at epa.gov