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

[Michael Schwartzkopff via amavis-users]

Am Donnerstag, 12. September 2013, 14:03:14 schrieb 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

no. Patrick ment something like:

http://dev.mysql.com/doc/refman/5.0/en/locale-support.html

-- 
Dr. Michael Schwartzkopff
Guardinistr. 63
81375 München

Tel: (0162) 1650044
Fax: (089) 620 304 13
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.amavis.org/pipermail/amavis-users/attachments/20130912/41a6bc88/attachment.html>