One additional consideration would be if you're planning on doing a lot of mailing you should consider having some sort of address validation software. Once you settle on that package, it will also help you determine maximum field/column sizes. After looking at the package(s) you may decide to offer more fields as well.
-----Original Message----- From: William Fong [mailto:[EMAIL PROTECTED] Sent: Friday, November 21, 2003 10:05 AM To: [EMAIL PROTECTED] Subject: Re: Choosing between VARCHAR and TEXT 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]