Re: Choosing between VARCHAR and TEXT

2003-11-22 Thread Paul DuBois
At 9:34 -0600 11/21/03, Paul Fine wrote: 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? What do you mean by "Text will pad"? I can think of two distinct possibilities, only one of whic

RE: Choosing between VARCHAR and TEXT

2003-11-21 Thread DChristensen
de 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 t

Re: Choosing between VARCHAR and TEXT

2003-11-21 Thread Patrick Shoaf
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 antici

Re: Choosing between VARCHAR and TEXT

2003-11-21 Thread William Fong
ED]> 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?

Choosing between VARCHAR and TEXT

2003-11-21 Thread Paul Fine
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/[EMAI