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