On Thu, Oct 14, 2004 at 10:27:11AM -0400, Jeremy Portzer wrote: > On Thu, 2004-10-14 at 10:24, Joseph Mack wrote: > > 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.
Another option, of course, would be to work with strings instead of numbers. B-)
signature.asc
Description: Digital signature
-- 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
