here's the skinny from MySQL.com: http://dev.mysql.com/tech-resources/articles/migrating-from-microsoft.html
On Thu, 14 Oct 2004 10:27:11 -0400, Jeremy Portzer <[EMAIL PROTECTED]> 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. > > 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 | > \---------------------------------------------------------------------/ > > > -- > 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 > > > -- 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
