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
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
It is always best to set fields sizes as small as possible, to both
conserve disk space, as well as improve performance. The smaller the
record the faster the queries. While you do not want to make any field too
small, you also don't want to make it too big. With current databases, you
can e
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 PRO