Dofactory.com
Dofactory.com
 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     Cookies       Do Not Sell       Licensing      
Made with    in Austin, Texas.  - vsn 44.0.0
© Data & Object Factory, LLC.