What is the ideal data type to use when storing latitude / longitude in a MySQL database?

Bearing in mind that I’ll be performing calculations on lat / long pairs, what datatype is best suited for use with a MySQL database? 21 Answers 21 Basically it depends on the precision you need for your locations. Using DOUBLE you’ll have a 3.5nm precision. DECIMAL(8,6)/(9,6) goes down to 16cm. FLOAT is 1.7m… This very … Read more