I have a search form where users can search by clients' first and last names. As quite a lot of the clients are foreign, I need to automatically search for accented characters as well. ie if the user enters Fred for first name and Surname for surname the results sould show eg.
for all the diffirent possible accented characters. All I can think of is to check the search string for a character that could have an accented character and then repeating the search for all possible combinations, but this seems very cumbersome and slow. Does anyone know of an easy way to do this?