-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
I realized this also. Martin Schwarz off list suggested to me to use
REGEXP for that purpose. That means that I'm rewriting the user input
"übersee" behind the scenes to "^(ü|ue)bersee.*" which works quote well.
The only gotcha is that the user m
MySQL doesn't have anything like that. You can use the wildcard
characters instead of the umlauts if you want, such as
SELECT * from person where name like "%bersee"
which would get
"übersee" and "uebersee"
but also a whole lot more.
But doing something like
SELECT * from person where name like
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
what is the best way to match german umlauts like 'ä' also their
alternative writing 'ae'?
For example I'm searching for "übersee" and I also want to find the word
"uebersee" in the database. The "words" are actually names of persons.
One possib
