Thanks to Peter, Ravi, and Dan. That's exactly what I needed to know.
----------
Aaron Conaway
Network Engineer III
Verisign, Inc. -- Telecom Services Division
http://www.verisign.com
Office: 912.527.4343
Fax: 912.527.4014
-----Original Message-----
From: Peter Hicks [mailto:pwh@stripped]
Sent: Tuesday, February 11, 2003 1:30 PM
To: Dan Nelson
Cc: Aaron Conaway; mysql@stripped; cc@stripped
Subject: Re: IP Addresses -- How to Store
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.
