I'm working with SQL Server 2005 and have to store the Lat and Lng for updates coming into the server. I was initially thinking of storing them as VarChars but the Decimal option seems better. I've been searching the forums and either I'm using the wrong keywords or the information isn't posted but what I'm looking for are the maximum values that lat and lng can be? Should I define the data type as Decimal(12, or can I go smaller? I just want to make sure that once it's done I won't have to go back and change them so I want to account for whatever the highest/lowest combination is.

Or do you think storing it as a VarChar(12) would be better?

Thanks in advance for any and all help that you can give. It is very much appreciated.

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

Originally Posted by C72831

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

Hello Every one.

I am developing a property portal.I have a google map,where the user will be able to specify the location of his property.Once the user specify his exact area(logi and lati) i need to save the same longitude and latitude so that when a user search for a region say that is all ready registred with us,will get displayed with the same location pointing in google map as well.

How can i store the selected longitude and latitude into my db?
i am using asp.net and c# as the code behind.

Or please tell me whether it is possible to directley store the selected area(latitude and longitude) in sql server 2005?

Please help me as it is very urgent to me.
Thank you all in advance.