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...
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
