ä is what you get when you take ä encoded as UTF-8 and interpret it as ISO-8859-1. So what probably happened, is that some text that was encoded as UTF-8 was treated as if it was ISO-8859-1/windows1252 and (unessearily) converted to UTF-8.
Common causes of this sort of thing:
- Very very old wiki from before MediaWiki adopted UTF-8 that wasn't upgraded properly. (I think MW adopted UTF-8 before MediaWiki 1.5, so it would have to be truly ancient).
- Restoring a DB from backup with some wrong options related to charset
- converting the charset of DB columns if they were originally mislabeled.
If its the entire DB that is broken, I think the easiest fix might be to take a DB dump, and use the iconv command line tool to convert UTF-8 -> windows-1252 (To undo one layer of conversion) and then import the result as if it was UTF-8.
--
brian.