Subject Re: Recommended floating-point type for latitude and longitude
Author George
--- In, "Daniel Albuschat"
<d.albuschat@...> wrote:
> Hello there,
> I'd like to save global latitude and longitude data in my database,
> which can look like this:
> Longitude: 7.33220348221289
> Latitude: 51.1492514558089
> My best guess is using numeric(18,2) and always multipy the value by
> 10000000000 before
> storing it to the database, but I'd like to hear your opinion on
> Regards,
> Daniel Albuschat
> --
> eat(this); // delicious suicide


Based purely on my distrust of the way different platforms handle
numbers like this I always store them as chracter strings.
This is just my personal preference and is probably based on
ignorance but has always been safe.