[TriLUG] Money in mysql

[Warren Myers]

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 <jeremyp at pobox.com> 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        jeremyp at pobox.com      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
> 
> 
>