The same way the kernel deals with them; int(10) unsigned. To convert a
dotted quad string into int(10) use the following:
Using 192.168.10.50:
192 + (168 * 2^8) + (10 * 2^16) + (50 * 2^24) = 839559360
This is real handy if you're doing low level socket stuff and storing
addresses in the database.
-Evan
Cory @ SkyVantage wrote:
> I'm using MySQL-Cluster 5.0, and we're doing some research.
> What is everyone's opinion as to what the best fieldtype to store an IP
> address in?
>
> varchar(16) ? because 16 is the max chars of an ip address...
> char(16) ?
> text(16)
>
> Not quite sure how to get the best memory utilization...
>
>
