Posted by The Eclectic Electric on 09/21/06 15:20

"ZeldorBlat" <zeldorblat@gmail.com> wrote in message
news:1158847559.017010.65770@i42g2000cwa.googlegroups.com...
>
> 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>
>

Thanks! I hope I can be as helpful to you sometime!

+e

[Back to original message]