Upgrade from debian squeeze to wheezy / problems with "umlauts" in mysql logging

[Bastian via amavis-users]

Am 12.09.2013 13:55, schrieb Patrick Ben Koetter via amavis-users:
> * Bastian via amavis-users <traced at xpear.de>:
>> 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 at rick
>
>

The default locale (hope this is the right config file?!) did not change:

root at gate1:~# cat /etc/default/locale
#  File generated by update-locale
LANG=de_DE.UTF-8

root at gate2:~# cat /etc/default/locale
#  File generated by update-locale
LANG=de_DE.UTF-8

gate1 now runs on wheezy.

Bastian