[TriLUG] Money in mysql

[Brian McCullough]

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-)

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
URL: <http://www.trilug.org/pipermail/trilug/attachments/20041014/e6255a27/attachment.pgp>