Zeichensatz-Konvertierung / TYPO3-Datenbank Zeichensatz / ...

echo "ALTER DATABASE mydb CHARACTER SET utf8 COLLATE utf8_general_ci;" | mysql

mysqldump --default-character-set=latin1 --databases mydb > a.sql

cp a.sql b.sql

sed -i 's/DEFAULT CHARSET=latin1/DEFAULT CHARSET=utf8/g' b.sql

sed -i 's/CHARACTER SET latin1/CHARACTER SET utf8/g' b.sql

grep -v character_set_client <b.sql > c.sql

sed -i 's/SET NAMES latin1/SET NAMES utf8/g' c.sql

mysql --default-character-set=utf8 < c.sql

http://wiki.typo3.org/UTF-8_support#Convert_an_already_existing_database_to_UTF-8

http://www.i18nqa.com/debug/utf8-debug.html

http://www.utf8-chartable.de/unicode-utf8-table.pl

http://stackoverflow.com/questions/14980200/converting-special-charactes-such-as-%C3%83%C2%BC-and-%C3%83%C6%92-back-to-their-original-latin-alp

https://docs.typo3.org/typo3cms/InstallationGuide/UpgradeLTS/Index.html

http://php.net/manual/en/function.utf8-encode.php

http://php.net/manual/de/function.mb-convert-encoding.php