[fpc-devel] MySQL 5.1 and Double (trouble)
Ludo Brands
ludo.brands at free.fr
Mon Jul 11 17:59:21 CEST 2011
> > It doesn't make sense to display more digits than stored in
> the binary
> > variable. There is no loss, only rounding errors in the conversion
> > from binary to decimal text.
>
> I need to compare values with complete precision. I don't
> think this problem was present a while ago.
>
> When the memory is copied is there a missing 12bits? Is
> there going to be a fix for this?
Exact compare with double is never a good idea. For MySQL read more here:
http://dev.mysql.com/doc/refman/5.0/en/problems-with-float.html
More information about the fpc-devel
mailing list