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]

Reply via email to