Thread: Storing Latitude and Longitude in a SQL Server 2005 DB?
View Single Post

  #3 (permalink)  
Old 11-01-2007
OOT OOT is offline
Junior Member
Yellow Belt
  
Join Date: Dec 2006
Posts: 14
Re: Storing Latitude and Longitude in a SQL Server 2005 DB?
Quote:
Originally Posted by C72831 View Post
I use Decimal(18,15) for storing them, since you need a high accuary (decimal places). Varchar is never a good choice for storing numbers.

Bernhard
Thank you for that. I thought going the varchar route would be a mistake. I didn't realize that the lat/lng number would be that high. Thank you for the information ... now I'm off to edit my database
Reply With Quote