在 MySQL 数据库中存储纬度 / 经度时，理想的数据类型是什么？

Question

Bearing in mind that I'll be performing calculations on lat / long pairs, what datatype is best suited for use with a MySQL database?

转载于:https://stackoverflow.com/questions/159255/what-is-the-ideal-data-type-to-use-when-storing-latitude-longitudes-in-a-mysql

Answer 1

Use MySQL's spatial extensions with GIS.