--- In firebird-support@yahoogroups.com, "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

this.

>
> Regards,
> Daniel Albuschat
>
> --
> eat(this); // delicious suicide
>

Daniel

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.

Cheers

George