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 - [EMAIL PROTECTED] -- TriLUG mailing list : http://www.trilug.org/mailman/listinfo/trilug TriLUG Organizational FAQ : http://trilug.org/faq/ TriLUG Member Services FAQ : http://members.trilug.org/services_faq/ TriLUG PGP Keyring : http://trilug.org/~chrish/trilug.asc
