mixed case text

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. Received on Wed Sep 11 2002 - 19:36:42 CDT