Re: IP Addresses -- How to Store

[Peter Hicks]

On Tue, 11 Feb 2003, Dan Nelson wrote:

> Store your addresses as INTs, so you would have three fields:
> "address", "netmask", and "gateway".  You can either encode the values
> yourself, or use mysql's INET_NTOA()/INET_ATON() functions.

...and beware, INET_NTOA/ATON calls aren't compatible (as far as I can see)
with PHP's equivilent calls.  PHP uses signed integers, and MySQL not.

Has anyone come up with a workaround to this on either the MySQL or PHP sides?


Peter.