存储纬度和经度的最佳mysql数据类型是什么？

Question

I got confused by the following 2 Questions already asked.

1. What is the ideal data type to use when storing latitude / longitudes in a MySQL database?
2. What MySQL data type should be used for Latitude/Longitude with 8 decimal places?

In the above questions someone is saying that decimal is a good datatype while someone is saying one should use MySQL's spatial extensions and others are saying using float is good because Google is also using float in their application here. So what should be the final solution for this problem?

Thanks

Answer 1

based on my experience if you need only lat and lng as seprated values an otimal solution is based on data type

decimal(16,12)

with this format you can localize point on maps with a precision very near to millimeter, and this for normal maps application is more than enough