Mysql – the ideal data type to use when storing latitude / longitude in a MySQL database

database-designlatitude-longitudemappingmapsMySQL

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

Best Answer

Use MySQL's spatial extensions with GIS.