Re: CHAR vs VARCHAR

[Rob McMillin]

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.