From: Claude Cormier
Date: August 21 2000 3:58pm
Subject: Re: CHAR vs VARCHAR
List-Archive: http://lists.mysql.com/mysql/48445
Message-Id: <39A151B0.B18D7E24@devises-or.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

That is exactly why I asked the question.

Rob McMillin wrote:
> 
> Claude Cormier wrote:
> 
> > Unless you need a small text column or the data entered will always have
> > a fixed number of characters, is there a good reason for not using
> > VARCHAR all the time instead of CHAR?
> 
> According to the docs, CHAR is faster because the rowsizes are all the same. I have to wonder about this, because accessing a larger table (and tables made up
> of strictly CHAR types would be sizeably larger) is generally slower.
> 
> --
>           http://www.pricegrabber.com | Dog is my co-pilot.