OK so... Next problem...
I was thinking of storing the IPs in my Database for several reasons, also I export myMysql data into a local MsSQL database once per day, so the column type would have to be compatible.
I was going to use CHAR(15) but there must be some more efficient way...
Any suggestions anyone?
In addition to this, if I want to
SORT BY `ipaddress`
in CHAR column would simply sort alphabetically, meaning 1, 100, 30, 325 when I need it to be 1, 30, 100, 325.
If that makes any sense.
Unlike, for example, PostgreSQL, MySQL doesn't have an "inet" datatype, nor does it have a mechanism for defining custom datatypes.
Since an IPv4 address can fit in an unsigned long (via [man]ip2long[/man]) it could be stored that way and it would sort as expected.
