Re: Advice on storing Upper/Lower case Key values then doing case insensitive searching; Phonetic matching.

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Sun, 11 Jul 1999 21:00:46 +0800
Message-ID: <3788957E.6C00@yahoo.com>

Jeffrey Wilkinson wrote:
>
> I'm looking for a good way to record key values that invlove upper/lower case
> characters. I need to be able to order and search the key columns in a case
> insensitive way.
>
> For example, I record the First and Surnames for people. I want to be able to
> record the names in the format that they are to be displayed (e.g, Mr Peter
> McAlistair) but I want to be able to index and search the information so that
> the case is irrelevant. The only way that I can think of now is to have one
> column to record the display value and then a second column to record the
> value that is to be searched and indexed.
>
> Also, I'm looking for some utilities that will enable the generation of
> phonetic keys so that, for example, Smith, Smythe, and Smit are regarded as
> similar names.
>
> Any suggestions will be greatly appreciated.
>
> Jeff

For phonetics, look at the soundex function...

For speeding searches, look at function-based indexes in 8i...

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Sun Jul 11 1999 - 08:00:46 CDT