|
|
|
| "be consistent" | |
| 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
|
|
||||||||||||||||||||||