phpmyadmin - Mysql how to stop rounding off decimals -


i have database table called location stores latitude , longitude , used float data type, every time store latitude , longitude round off. example: when store latitude of 14.5976 stay same in phpmyadmin when store longitude of 121.0176, round off 121.018.

the float data type stores approximate values. see following description.

https://dev.mysql.com/doc/refman/5.7/en/floating-point-types.html

for exact numbers, want use decimal.

https://dev.mysql.com/doc/refman/5.7/en/fixed-point-types.html


Comments