[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