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
Post a Comment