IMHO, I prefer to use both, mixed case text for reports, etc. and upper case text for
searches, etc. What's a few more characters in the db when it keeps everyone happy :)
Gene
[EMAIL PROTECTED] 09/12/02 10:18AM
Steve,
From one dinosaur to another, let them have mixed case.
Dick Goulet
Reply Separator
Author: Steve McClure [EMAIL PROTECTED]
Date: 9/11/2002 5:38 PM
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.
Steve
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steve McClure
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gene Sais
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
