Am 12.09.2013 13:55, schrieb Patrick Ben Koetter via amavis-users: > * Bastian via amavis-users <[email protected]>: >> Hi there, >> today i did an upgrade from squeeze to wheezy, resultin in an amavis >> update to version 2.7.1-2, and mysql is now 5.5. >> I am logging amavis mails to mysql, but after the update, german umlauts >> look like this: >> >> mysql> select subject from amavis.msgs where subject like "%und fusionen%" ; >> +----------------------------------------------------------------+ >> | subject | >> +----------------------------------------------------------------+ >> | Ãœbernahmen und Fusionen - Schäppchenjagd für Anleger? | >> | Übernahmen und Fusionen - Schäppchenjagd für Anleger? | >> +----------------------------------------------------------------+ >> 2 rows in set (0.01 sec) >> >> The second mail was logged before the update. Can someone please give me >> a hint what the problem could be, >> and if it is related to amavis, how to resolve this? The DB collation >> did not change. > The default locale on your system changed. Set the locale explicitly in your > MySQL amavisd database. > > p@rick > >
The default locale (hope this is the right config file?!) did not change: root@gate1:~# cat /etc/default/locale # File generated by update-locale LANG=de_DE.UTF-8 root@gate2:~# cat /etc/default/locale # File generated by update-locale LANG=de_DE.UTF-8 gate1 now runs on wheezy. Bastian
