amavisd-new with sql quarantine and emojis in e-mail subject

Joerg Rohrer joerg at
Tue Mar 8 11:22:40 CET 2016


Recently i saw in the mail logs the following message:

amavis[893]: (00893-12) (!)WARN save_info_final: sql exec: err=1366, 
22007, DBD::mysql::st execute failed: Incorrect string value: 
'\134xF0\134x9F\134x8C\134xB7' for column 'subject' at row 1 at (eval 
98) line 172, <GEN19> line 2763.

I figured out that those e-mail has some sort of emoji in the subject, 
and amavis cannot store it in mysql.
Anyone else see the same or have already a fix?

Repository: openSUSE-13.2-Oss
Name: amavisd-new
Version: 2.9.1-3.1.4
Arch: x86_64

Repository: openSUSE-13.2-Update
Name: mariadb
Version: 10.0.22-2.21.2


More information about the amavis-users mailing list