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 -> FBI or Shadow column?

FBI or Shadow column?

From: Paul <paul_at_see.my.sig.com>
Date: Wed, 13 Jul 2005 13:31:45 +0100
Message-ID: <412ad1pcf7uvrkv9gorklq1eifg72mboul@4ax.com>

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...

-- 

plinehan __at__ yahoo __dot__ __com__

XP Pro, SP 2, 

Oracle, 9.2.0.1.0 (Enterprise Ed.)
Interbase 6.0.1.0;

When asking database related questions, please give other posters 
some clues, like operating system, version of db being used and DDL.
The exact text and/or number of error messages is useful (!= "it didn't work!").
Thanks.
 
Furthermore, as a courtesy to those who spend 
time analysing and attempting to help, please 
do not top post.
Received on Wed Jul 13 2005 - 07:31:45 CDT

Original text of this message

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