Re: Best Fieldtype to store IP address...

[pekka]

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