Re: Select statement drops 10th digit during table lookup?
| From: | Jason Wong | Date: | Fri, 13 Jun 2003 08:56:53 +0000 |
| Subject: | Re: Select statement drops 10th digit during table lookup? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-28594@lists.php.net to get a copy of this message | ||
On Friday 13 June 2003 15:48, G & E Holt wrote:
> I hope this is something easy I am overlooking but here goes:
>
> I have a table called: country which has the following fields:
>
> Field Type
> ip_from double(11,0)
> ip_to double(11,0)
> country_code char(2)
> country_name varchar(50)
Shouldn't you be using some INTEGER type instead of DOUBLE? An unsigned INT
will just about handle it (2^32).
--
Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
------------------------------------------
Search the list archives before you post
http://marc.theaimsgroup.com/?l=php-db
------------------------------------------
/*
It seems like the less a statesman amounts to, the more he loves the flag.
*/