Internationalisation: SELECT str (ignoring Umlauts/Accents)

Hi there,

has anyone done a good implementation of a search algorithm, that would
allow searching for a string, with automatic use of alternate forms for
Umlauts ('ae' in a search string matches the a-Umlaut ), or allowing to
search without knowing the correct accents ( 'a' in a search string also
matches 'à', 'e' also matches 'é', ... )?

This should - of course - work one-way only, i.e. if a string in the
database contains "ae" and the search string contains the German a-Umlaut,
then the string containing ae should not be matched, while the other way
around it should.

Ideas anyone?

Benedikt

Windows 95: n.
32-bit extensions and a graphical shell for a 16-bit patch to an 8-bit
operating system originally coded for a 4-bit microprocessor, written
by a 2-bit company that can't stand for 1 bit of competition.