We use float. I have no idea if that's better or worse, but that's what we use.
-Sheeri
On 4/26/06, René Fournier [EMAIL PROTECTED] wrote:
Just curious the majority use. I've been using decimal(18,14), but
that appears bigger than necessary... Maybe varcar(21) for latitude,
and varchar(22)
I worked on a system years ago that used binary encoded integer for
latitude longitude.
The Most Significant Bit (MSB) was a sign bit ( + or -).
The next bit was 180 degrees
The next bit was 090 degrees
The next bit was 045 degrees.
etc
Functions were written to transform these into human
Just curious the majority use. I've been using decimal(18,14), but
that appears bigger than necessary... Maybe varchar(21) for latitude,
and varchar(22) for longitude?
...Rene
Just curious the majority use. I've been using decimal(18,14), but
that appears bigger than necessary... Maybe varcar(21) for latitude,
and varchar(22) for longitude?
...Rene