Jerry Schwartz wrote:
An employee of a financial institution realized a similar vulnerability in
their systems. It was common to calculate batch totals, which were cross
checked to make sure that no transactions went astray, but he realized that
so long as the batch totals came out right you coul
--Original Message-
From: Renato Golin [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 07, 2006 6:40 PM
To: Gerald L. Clark
Cc: mysql@lists.mysql.com
Subject: Re: Decimal versus Float Point Type
> How do you expect to split a dollar 3 ways?
Sorry, I should have added more smiles, it was sup
> How do you expect to split a dollar 3 ways?
Sorry, I should have added more smiles, it was supposed to be a joke about
the dollars... ;)
But still, I could win a lot of money by distributing people's money to
their three kids and getting 1 cent out of every operation. :D
> It is not the math
Renato Golin wrote:
Jerry Schwartz wrote:
The difference is that, for example, .01 can be represented exactly
in decimal; but float types are binary, so .01 cannot be represented
exactly. This can lead to all kinds of trouble when doing arithmetic,
the errors accumulate.
Yes! but that can a
Jerry Schwartz wrote:
The difference is that, for example, .01 can be represented exactly
in decimal; but float types are binary, so .01 cannot be represented
exactly. This can lead to all kinds of trouble when doing arithmetic,
the errors accumulate.
Yes! but that can also lead to some other
Oooh, oooh, I know!
The difference is that, for example, .01 can be represented exactly in
decimal; but float types are binary, so .01 cannot be represented exactly.
This can lead to all kinds of trouble when doing arithmetic, the errors
accumulate. It's one reason why most people write their loop
Bruno Rodrigues Silva wrote:
Dear all.
The MySQL Manual inform that Decimal Data Type is used
for represent exact-number, but like Float Point Data
Type, Decimal use rounding case the fractional part is
not sufficient. Therefore, what the difference?
Hi Bruno,
FLOAT rounds as floating point