wawersich - 2012-05-04

If You should see "Schüler können mähen"
but You see something like "Schüler können mähen" You should fix your Database.

First make a latin1 mysqldump:

mysqldump --host=<db-host> --user=<db-user> --password=<db-passwd> --quick --no-create-db --add-drop-table -c -l -C --default-character-set=latin1 --default-character-set=latin1 <db-name> > dump.sql</db-name></db-passwd></db-user></db-host>

Then konvert the UTF-8 Strings:
utf8-fix.pl dump.sql

And then instert the new data to the Database (or better into a new Database)
mysql --host=<db-host> --user=<db-user> --password=<db-passwd> --database=<db-name> < dump.sql.converted</db-name></db-passwd></db-user></db-host>