Posted by ZeldorBlat on 09/21/06 14:05

The Eclectic Electric wrote:
> From a performance perspective, assuming my table might grow to a sizeable
> number of entries, is it better to use VARCHAR or CHAR? Intitution says
> that CHAR would obviously be faster to search through, but if I'm not using
> the VARCHAR element in a WHERE clause then it's probably better to use
> VARCHAR since it keeps the size of the table down and therefore more likely
> to be in memory? Is this correct?
>
> +e

Here's an excellent article on the subject:

<http://www.google.com/search?q=char+versus+varchar>

[Back to original message]