[ale] Decimal Degrees in MySQL

[Atlanta Geek]

If you know to what precision you want to work in I would suggest a 32
bit Integer.  Then format the data when displaying it.

On Wed, Mar 12, 2008 at 4:11 PM, Christopher Fowler
<cfowler at outpostsentinel.com> wrote:
> Can someone tell me the best way to store decimal degrees in MySQL?
>
>  I want to create columns named ddlat and ddlon.  I'm not sure if I
>  should use a float,double, or just a string.
>
>  Decimal Degrees is formated like this:
>
>  (-)XXX.XXXXXX
>
>  Chris
>
>
>  _______________________________________________
>  Ale mailing list
>  Ale at ale.org
>  http://mail.ale.org/mailman/listinfo/ale
>



-- 
Stability is for the weak!!!
Long live the next big thing.