From: Date: November 11 2005 9:50pm
Subject: Re: Best Fieldtype to store IP address...
List-Archive: http://lists.mysql.com/cluster/2782
Message-Id: <20051111205042.GA13242@mysql.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1

> varchar(16)  ?  because 16 is the max chars of an ip address...
> char(16) ?
> text(16)

Assuming you want it as text for easy searches, char(16).
In 5.0 varchar(16) just uses unnecessary extra 4 bytes.
Even in 5.1 (which has true varchar) I'd use char(16).

text(16) is a blob and uses 8+256 bytes in 5.0.

-- 
Pekka Nousiainen, Software Engineer
MySQL AB, www.mysql.com
pekka@stripped +46 (0) 73 068 4978