Wednesday, April 12, 2006

longitude and latitude fun

when i first set wrote the screenscrape i chucked up a database for it to write to with the lat and lng being saved as varchar s. obviously this is shite so i started looking at the corrcet data type to store them as.

Eventually after much pain and fannying around with floats (bad idea leave them alone) i have a latitude and longitude field in my database with the following data type

Decimal(9) with a scale of 6 and a precision of 18 (the default).

No comments: