Views: 11.6K
Replies: 1
Archived
|
Appropriate datatype for Latitude and Longitude in SQL ServerI 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 1PLease try to create a user-defined type for your own need
Tarriq Ferrose Khan, Aug 26, 2011
|