----- Original Message ----- From: "Peter M. Groen" <[EMAIL PROTECTED]> To: <mysql@lists.mysql.com> Sent: Friday, November 11, 2005 3:37 PM Subject: Re: Best Fieldtype to store IP address...
> 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... > Isn't there a new way to express IP addresses called IPV6(?) which has a possibility of 6 distinct parts instead of the traditional 4? I haven't seen one of these new formats myself yet but for all I know, they will become soon in the near future. Maybe you'd better choose a field type that can accomodate those as well as the traditional 123.123.123.123 type.... Rhino -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.362 / Virus Database: 267.12.8/165 - Release Date: 09/11/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]