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

mysql database-design maps mapping latitude-longitude
Codebeef picture Codebeef · Oct 1, 2008 · Viewed 315.9k times · Source

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

Answer

Kirk Strauser picture Kirk Strauser · Oct 1, 2008

Use MySQL's spatial extensions with GIS.

Related questions

Remove Primary Key in MySQL

I have the following table schema which maps user_customers to permissions on a live MySQL database: mysql> describe user_customer_permission; +------------------+---------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +------------------+---------+------+-----+---------+…

Read More
Auto Generate Database Diagram MySQL

I'm tired of opening Dia and creating a database diagram at the beginning of every project. Is there a tool out there that will let me select specific tables and then create a database diagram for me based on a …

Read More
What does character set and collation mean exactly?

I can read the MySQL documentation and it's pretty clear. But, how does one decide which character set to use? On what data does collation have an effect? I'm asking for an explanation of the two and how to choose …

Read More