🚀 go-pugleaf

Moore wrote:
> in a float field when i write 3,2 it shows 3,20000004768372
> why and what is the best solution for this???

Use a double. That's what I did. Otherwise you have to control the 
display of the numbers using edit masks and so on in the client program.

If you wonder why you are getting this result look up the formats for 
floating point and double numbers etc. in the IEEE specs -- for example.

Simplistic explanation... The float format is an approximation of most 
floating point numbers and does not have enough guard digits to "throw 
away" the spurious decimals. A float is expressed as a mantissa and 
exponent that are too low in precision (# of digits) to provide the 
accuracy (correctness) you wish to see.


http://www.google.ca/search?hl=en&q=IEEE+Float+double+specification&btnG=Search&meta=

The float type can represent values ranging from approximately 1.5 × 
10-45 to 3.4 × 1038 with a precision of 7 digits.

The double type can represent values ranging from approximately 5.0 × 
10-324 to 1.7 × 10308 with a precision of 15-16 digits.


-- 
Will R
PMC Consulting