robertomurray.co.uk Blogging, web development and travelling from a network engineer in UK
  • Home
  • About
  • Blog
  • Contact
  • Gallery
  • Maps
  • Travels
    • Africa
    • Central America
    • Europe
    • South America

Best MySQL data type for latitude and longitude

November 22, 2008

I was trying to think of the most efficient datatype to store decimal latitude and longitude points in a MySQL database but my usual tutor Mr Google wasn’t all that helpful. Anyway, I went for this in the end; float(10,6) This will easily store negative and positive to 6 decimal… [...]

No Comments

Read the post

Categories

Africa 2008 Apple Central America 2009 Checkpoint Database Fitness Fixes Football General GI IT Java Javascript Linux Mapping Microsoft Music Open Data Photography PHP Postgresql Programming robertomurray.co.uk Ruby on Rails Shell script Sport Tech Stuff Thailand 2012 Travelling Uncategorized Unix VBScript VMware Walking Web ZFS
  • http://robertomurray.co.uk | 2012
  • Powered by thought and invention
    Hopefully valid HTML5 + CSS