tags:

views:

281

answers:

7
+4  Q: 

What datatype is suitable for storing latitudes and longitudes?

what should be the data type of latitudes and longitudes in general

+2  A: 

In MySQL, it should be Point, so that you can run efficient SPATIAL queries.

Quassnoi  2009-07-15 12:40:46
Could you please link to any documentation about this data type? Some googling seems to confirm its existence, but I can't find it in the official docs. Thanks!
deceze  2009-07-15 12:57:21
@deceze: first Google result for `mysql point` yields this: http://dev.mysql.com/doc/refman/5.0/en/gis-class-point.html
Quassnoi  2009-07-15 13:16:17
Weird. I guess I was googling for "point data type mysql" or something to that extend. A search for "point" on the MySQL site only yielded references to "floating-point"...
deceze  2009-07-16 02:28:45
A: 

I would say double if you want to store them in separate columns.

J.W.  2009-07-15 12:41:20
A: 

I have used varchar2(40) under Oracle.

blispr  2009-07-15 12:42:56
may i know y u r using varchar
srinivas  2009-07-15 12:47:04
WTF should previous comment mean? :mad: I looked at some english dictionaries, but words like "y", "u" and "r" seem have no meaning.Sorry, english is not my language.
Arvo  2009-07-15 13:00:15
Is "WTF" part of your language? If u know what "WTF" means - u should know what "y" and "u" mean.
Jim Evans  2009-07-15 13:19:44
A: 

Depends on the language/DB you are using. In general, its preferable to have it as float, in case of programming language. and NUMBER(x,y) in case of sqlplus.

Roopesh Majeti  2009-07-15 12:45:29
+2  A: 

For SQL Server 2000 and 2005, I've seen Numeric(15,10) for each coordinate used most often although I cannot speak to the correctness of that.

Sql Server 2008 has new spatial data types. See here for more on those (its a little more than half way down the page).

Rob Allen  2009-07-15 12:47:09
A: 

look i have implemented google maps in my website. I've used blob for latitude and longitudes(just to be on the safer side)

ROHAN CHAVAN  2009-07-15 12:48:48
Using BLOBs to store Geographical locations is totally unnecessary. The precision of a Geographic location is only 6 digits Lat, 6 digits Long
TreeUK  2009-10-23 22:32:19
A: 

in general int (on Intel x86 in 32bit mode) is sufficient (in 100 (")representation). sign is used to indicate N/S and E/W. brgds/gabriel

 2009-07-15 13:11:02

related questions

Remove Quotes and Commas from a String in MySQL
What's the best way of converting a mysql database to a sqlite one?
How do you manage databases in development, test, and production?
Multiple foreign keys?
Add 1 to a field (MySQL)
Issues using MS Access as a front-end to a MySQL database back-end?
Bigger than a char but smaller than a blob
How do I retrieve my MySQL username and password?
Long-time LAMP Developer moving to VB.NET
How do I Concatenate entire result sets in MySQL?
Full complete MySQL database replication? Ideas? What do people do?
SQL: Distribution of table in time
SQLite vs MySQL
How do I create a new Ruby on Rails application using MySQL instead of SQLite?
Multiple Updates in MySQL
MySQL/Apache Error in PHP MySQL query
What all do I need to escape when sending a (My)SQL query?
Auto Generate Database Diagram MySQL
Mechanisms for tracking DB schema changes
How big can a MySQL database get before performance starts to degrade.
Python and MySQL
SQL Server 2005 implementation of MySQL REPLACE INTO?
How to export data from SQL Server 2005 to MySQL
Throw Error In MySQL Trigger
Binary Data in MySQL