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. > Does mysql have BCD?
I don't think BCD is found much these days, but as already discussed, the equivalent form is to do everything in cents, but divide by 100 for displaying in dollars. Jeremy -- /---------------------------------------------------------------------\ | Jeremy Portzer [EMAIL PROTECTED] trilug.org/~jeremy | | GPG Fingerprint: 712D 77C7 AB2D 2130 989F E135 6F9F F7BC CC1A 7B92 | \---------------------------------------------------------------------/
signature.asc
Description: This is a digitally signed message part
-- 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
