Posted by Pete on 02/04/06 01:19

> If you look at the mysql doc (
> http://dev.mysql.com/doc/refman/4.1/en/numeric-types.html ), you shall
> see that you can use a "INT UNSIGNED"

Thank you!
INT UNSIGNED seems to work fine. I am not sure how the inet_aton works, but
I guess the highest number in the database comes from the number of IPs
available. 4,294,967,295 is the same as 256*256*256*256 (minus 1, because
INT UNSIGNED uses 0 too).

I guess int unsigned is the optimal solution giving med the smallest
database possible (and possibly fastest too).

• Next in forum: Re: BBS-type Echos on the Internet -- would this be possible???
• Prev in forum: Re: Reading from file
• Thread view: Re: Storing IP in MySQL as DOUBLE or INT ?

[Reply to this message]