Friends the situation is this. There is a float field in the database. When I enter data into it manually, or through a script, for example 7.77 for some reason in a cell it becomes 7.8. It turns out that there is some kind of auto rounding. How can I turn it off?

7.78 = > 7.8
  • Can in the database define the type as FLOAT(5,2) that is 5 (a digit from the head means the total length) of which 2 decimal places, or how much you need. In general, Float is not the most accurate type. If good accuracy is needed, Decimal should be used - Aleksey Shimansky
  • Thank you very much! Probably, as you say, I will use Decimal - WhoIsDT

0