On Friday 11 November 2005 21:33, 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...
How about:
Field 1: First octet (int)
Field 2: Second octet (int)
Field 3: Third octet (int)
Field 4: Fourth octet (int)
Fester.
Searching takes less time like this, I reckogn..
Fester
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
