Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: FBI or Shadow column?
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