Re: Select statement drops 10th digit during table lookup?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.
*/


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux