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 readable vlaues. The beauty of this was that integer addition and subtraction could used directly on these values.
On 5/12/06, sheeri kritzer <[EMAIL PROTECTED]> wrote:
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) for longitude? > > ...Rene > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]