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: -CELKO- <jcelko212_at_earthlink.net>
Date: 19 Aug 2005 14:37:55 -0700
Message-ID: <1124487475.040190.66930@z14g2000cwz.googlegroups.com>


>> 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 - 16:37:55 CDT

Original text of this message

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