I have seen several answers but none seem to work ... I need to know the best MySQL data type to store a lat / lon value. An example lon value returned from the API:
-75.2408658
Currently, I have the column set to Decimal(10,7)
, but this rounds the value to the nearest tenth and stores as such:
-75.2408660
Any help would be greatly appreciated!!