Back to list
Views:   11.6K
Replies:  1
Archived

Appropriate datatype for Latitude and Longitude in SQL Server

I need to store Latitude and Longitude data in SQL Server.  
The data comes from Google in the following format: xxx.xxxxxx.

I was thinking of using DECIMAL(9,6).
Is this accurate enough for subsequent distance and other calculations?

Thanks,
Graig.
Craig Johnston, Jul 14, 2011
Reply 1
PLease try to create a user-defined type for your own need
Tarriq Ferrose Khan, Aug 26, 2011


Stay Inspired!
Join other developers and designers who have already signed up for our mailing list.
Terms     Privacy     Licensing       EULA       Sitemap      
© Data & Object Factory, LLC.
Made with    in Austin, Texas.      Vsn 1.2.2