Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: SQL Humor

Re: SQL Humor

From: JT <someone_at_microsoft.com>
Date: Fri, 19 Aug 2005 10:49:59 -0400
Message-ID: <uKelj2MpFHA.1416@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-" <jcelko212_at_earthlink.net> wrote in message news:1124403285.842828.168210_at_g43g2000cwa.googlegroups.com...
>>> 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 - 09:49:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US