Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: FBI or Shadow column?

Re: FBI or Shadow column?

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Thu, 14 Jul 2005 09:26:31 +0200
Message-ID: <db5438$b4b$1@news.BelWue.DE>


Paul wrote:
>
>
> From a general viewpoint, what is the best way to search a db for
> someone's name? Using a Function Based Index on UPPER(Last_Name) or
> using a trigger to insert data into a Shadow Column, i.e. on INSERT or
> UPDATE :new.Shadow := UPPER(Last_Name)?
>
>
> I'm asking this in the context of where it is very important to keep
> the original case of the name as given by the person, because for
> example, a name like Colm Ua hUigínn is a valid name in Irish, and
> indeed, capitalising the "h" is a mistake, even if the rest of the
> name is UPPERED.
>
>
>
> I did this using a shadow column in another db system (see .sig), and
> am just wondering about the advantages/disadvantages of shadows versus
> FBI's. I'm assuming that the extra column needed is, to all intents
> and purposes, negligible.
>
>
> Paul...
>
>

The advantages of FBI:

disadvantages:

None that I'd loose sleep about

Cheers,
Holger Received on Thu Jul 14 2005 - 02:26:31 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US