Problems? Is your data what you think it is? | |
PerlMonks |
Re: Re: Handling caps for surnames with capitals in the middle (was: Irish Surnames)by derby (Abbot) |
on May 06, 2002 at 12:59 UTC ( [id://164313]=note: print w/replies, xml ) | Need Help?? |
This is the way I would do it also. Store the data
exactly as the user enters it (or supplies it). Then
use either functional indexes if your back-end supports
it or add another field that is the canonacalized version
(all lower, all upper, stripped of spaces, etc).
-derby
In Section
Seekers of Perl Wisdom
|
|