Re: SQL Humor

From: JT <>
Date: Fri, 19 Aug 2005 10:49:59 -0400
Message-ID: <uKelj2MpFHA.1416_at_TK2MSFTNGP09.phx.gbl>

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-" <> 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

Original text of this message