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