Will any names or addresses exceed 255 characters? The documentation recommends to use the smallest column size possible.
-will Real-time Chat: irc.freenode.net -> #mysql ( http://www.mysql.com/doc/en/IRC.html ) ----- Original Message ----- From: "Paul Fine" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, November 21, 2003 7:34 AM Subject: Choosing between VARCHAR and TEXT > Can anyone tell me what is better to use for items such as names and > addresses? I suspect VARCHAR(max anticipated length) but why? Is it because > Text will pad? > > > Thanks! > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]