Re: A WTF in the Oracle reference...

fitzjarrell_at_cox.net írta:
> Comments embedded.
> chaoslight_at_gmail.com wrote:
> > Here's a quote from the Oracle reference guide, page 27:
>
> Really ... which guide would that be? I find no such 'quote' on any
> page 27 of any Oracle documentation at tahiti.oracle.com.

Oracle9i: The Complete Reference, by "Kevin Loney, George Koch, And the Experts at TUSC".

> > "There are ways to find information from the database regardless of
> > whether the data is in uppercase or lowercase, but these methods impose
> > an unnecessary burden. With few exceptions, such as legal text or
> > form-letter paragraphs, it is much easier to store data in the database
> > in uppercase. It makes queries easier and provides a more consistent
> > appearance on reports. When and if some of this data needs to be put
> > into lowercase, or mixed uppercase and lowercase (such as the name and
> > address on a letter), then the Oracle functions that perform the
> > conversion can be invoked. It will be less trouble overall, and less
> > confusing, to store and report data in uppercase."
> >
>
> Obviously this is a fabrication intended to do nothing more than
> provoke an argument, as it does not resemble, even remotely, the
> writing style found in the Oracle documentation. Why would any
> reliable database vendor make such ludicrous statements in their
> reference manuals? Never have I seen any such 'recommendation' from
> Oracle; possibly you were perusing the Mysql documentation or your
> class text and thus attributed this incorrectly.

.... heh.

> > Is it just me, or is this advice profoundly retarded?
>
> Possibly it's the original poster who's 'retarded' by posting such
> nonsense in hopes of a flame war....

Are you always this shrill?

> > I'd love to see
> > what those Oracle functions would do with a name like MacDonald, or a
> > company name like eBay.
>
> The same thing such functions would do in SQL Server, Sybase, Informix,
> Mysql or DB2:
>
> > Laszlo <=== not your real name, obviously, as trolls post in attempted anonymity

You bore me now.

Laszlo Received on Wed Jan 18 2006 - 07:01:31 CST