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]