Re: SQL Humor
Date: Fri, 19 Aug 2005 10:49:59 -0400
Perhaps I'm misreading your point, but it's data in a Char column that typically contains trailing blanks that need a Trim. A VarChar won't contain extraneous blanks unless the developer explicitly includes them in the value.
"-CELKO-" <jcelko212_at_earthlink.net> wrote in message
>>> Any benchmark demonstrating that the performance degradation is not in
>>> single percentage digits is welcome. <<
> I am more worried about various numbers of extra blanks in the
> VARCHAR(n) making display problems. Trimming and padding are costly.
Received on Fri Aug 19 2005 - 16:49:59 CEST