MySQL is rounding out and trunking the number
Posted on 2009-06-28
Hi Every one,
I have mySQL server running on a VM, its been working fine, and I have over 200,000 record saved on it, until couple of days ago that one of the user entered $ amount of 33448.67 on the application, but on the MySQL it got saved 33448.70 ( instead of .67 got saved as .70) I tried to edit it in the MySQL but it did a same thing, is jut trunking it up. I removed one digit from the beginning decimal digits and it got saved fine!!
I looked at the field parameters, the Data type of this field is "Float" I tried to change it to double but it wouldn't change and I got an error that Field " is not valid!
I tried to change the Width and decimals and still I got a error message too.
I have to say that I'm using Webmin interface to connect to the Mysql