----- 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]

Reply via email to