Initcap?
What about:
abc garage
at&t
Mcneil and McNeil
Sivan Rabinovitz <[EMAIL PROTECTED]>@fatcity.com on 09/12/2002
03:33:18 AM
Please respond to [EMAIL PROTECTED]
Sent by:[EMAIL PROTECTED]
To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Do you know initcap
Title: RE: mixed case text
SELECT INITCAP('mccoy') "McCoy" FROM DUAL;
McCoy
-
Mccoy
Better hope your name isn't Hatfield!
(Alluding to the famous Hatfield-McCoy feud in the USA a few years ago).
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc
Steve,
I agree with what everyone said here. The data should be stored as the user
enters it. I regularly add additional columns to database table that will
take a name field, upper-case it and remove all punctuation for sorting
purposes. I do this with a database trigger, so applications do n
The initcap function can work pretty well in a lot of cases but those
exceptions can be major. I remember there being discussions on this
list about how does one handle names starting with Mc or Mac. At the
time the original post came in I was dealing with some strings that
included the degrees MD
Well said, Philip. I have always used mixed case for the actual data stored
in the database and have never encountered a problem, except the index issue
you mention, and as you say, function-based indexes cure this problem.
If you uppercase the data on storage and rely on initcap to replicate t
Sivan Rabinovitz[SMTP:[EMAIL PROTECTED]] wrote:
> >Do you know initcap function?
> >
> >
> >SELECT INITCAP('the soap') "Capitals" FROM DUAL;
> >
> >Capitals
> >-
> >The Soap
>
OK, how about Jaap van der Meer. Or any of a thousand other real-world
names that people, places and events have
Do you know initcap function?
SELECT INITCAP('the soap') "Capitals" FROM DUAL;
Capitals
-
The Soap
-Original Message-
Sent: Thursday, September 12, 2002 5:23 AM
To: Multiple recipients of list ORACLE-L
Far be it from me to call you a dinosaur, but it is my personal opinion
th
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
