> 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 [EMAIL PROTECTED] +46 (0) 73 068 4978 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
