Re: Best Fieldtype to store IP address...

[Evan Borgstrom]

	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...
> 
>