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

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

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

Do the math! Six decimal places is enough precision to distinguish two lovers kissing. 8 or 12 is ludicrous. Here is a list of likely choices.

FLOAT gives you a resolution of 1.7 meters or 5.6 feet. 39.95467480000001, -75.19447579999996 is an artifact of the displaying 39.9546748, -75.1944758.