Re: Matching of german umlauts with LIKE

2006-03-23 Thread Markus Fischer
-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

Re: Matching of german umlauts with LIKE

2006-03-23 Thread sheeri kritzer
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