Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: mixed case text

Re: mixed case text

From: Philip Douglass <>
Date: Wed, 11 Sep 2002 22:18:10 -0400
Message-Id: <>

Far be it from me to call you a dinosaur, but it is my personal opinion that unless you have a strong business reason to the contrary, text should be stored in the database in its "natural" form, i.e. mixed case where appropriate. No function that I can even conceive of could handle the variety of address forms/names/etc and output them in a "proper" form. Even if you get it pretty close, there are going to be more than a few exceptions. And there's no excuse not to allow mixed case in the database now that you can use functional indexes. Once again this is just my
(possibly humble) opinion from my own personal experience.

I just had a heated, well perhaps not heated, but certainly adversarial discussion with my manager regarding mixed case text. My position...Keep it out of the database. His position ...same case text looks amateurish when output, and the database should readilly accomodate it. He almost seems to think my objection is related to a shortcoming in Oracle..."I used to do that in Clipper 12 years ago".

It is my opinion that if you want to output mixed case data you should use functions to "beautify" text like names and addresses. My biggest objection is that by allowing mixed case text in a table, you are setting up developers (and me) to write queries that don't work. In order to get proper results from a query you have to upper() every single query involving the columns in question. To me this is far more annoying/complicated than calling functions when writing the relatively few reports that require "Proper" text.

So am I a dinosaur? Maybe it is because I am not writing the reports that are complicated by my decision to upper() everything while loading.


Please see the official ORACLE-L FAQ:
Author: Steve McClure

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L

(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Wed Sep 11 2002 - 21:18:10 CDT

Original text of this message