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...
>
>
Does it matter?
You will always use the original data for display purposes; the
FBI or shadow column will only be used in joins, searches, and the like.
For internal purposes, so to say.
--
Regards,
Frank van Bortel - No capitalizing the "v", please :)
Received on Wed Jul 13 2005 - 13:32:06 CDT
