Re: SQL Humor

From: -CELKO- <>
Date: 19 Aug 2005 14:37:55 -0700
Message-ID: <>

>> A VARCHAR(n) won't contain extraneous blanks unless the developer explicitly includes them in the value. <<

Not the developer, the data entry person who is probably an end user these days. The DB guy's job is to add a constaint like "CHECK (TRIM (BOTH foobar) = UPPER (foobar))" to the column on his side. Now how often have you seen Newbies go to that trouble?

Instead you see a lot of VARCHAR(50) -- notice the magic number fifty from ACCESS programmers -- columns which will eventually collect garbage, like 40 spaces and a period. Even worse, NVARCHAR(50) whcih collect garbage in Chinese! Received on Fri Aug 19 2005 - 23:37:55 CEST

Original text of this message