I'm trying to get mysql to use the latin1_german2_ci collation. This collation is supposed to translate German umlauts (ä, ü, ö) into their counterparts (ö=oe, ü=ue, ä=ae) back and forth. Both forms are valid in German.

I need mysql to return all records that contain either one of these forms. If I run a search on "bär" I also want to get strings that contain "baer".

I set all mysql variables to latin1 and latin1_german2_ci, but it still does not work. I'm not sure if I'm getting this all wrong or if there's some error in my setup.

Please read [dev.mysql.com...] Scroll down to the part where it says what the german collations do. Is it just for sorting, or should a search on "ö" also return "oe"?

Thanks for any help!

Cheers