[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[ale] Decimal Degrees in MySQL
- Subject: [ale] Decimal Degrees in MySQL
- From: atlantageek at gmail.com (Atlanta Geek)
- Date: Fri, 14 Mar 2008 09:51:29 -0400
- In-reply-to: <[email protected]>
- References: <[email protected]>
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.