Hello John,
this sounds like a bug. Could you open an entry at http://bugs.otrs.org please and attach a failing raw email to it please?
Best regards,
Martin Gruner
Team Lead R&D
OTRS AG
Bahnhofplatz 1a
94315 Straubing
T: +49 (0)6172 681988 0
F: +49 (0)9421 56818 18
I: www.otrs.com/
Geschäftssitz: Bad Homburg, Amtsgericht: Bad Homburg, HRB 10751, USt-Nr.: DE256610065
Aufsichtsratsvorsitzender: Burchard Steinbild, Vorstand: André Mindermann (Vorsitzender), Christopher Kuhn, Sabine Riedel
Mobile Kommunikation und transparente Prozesse - Mit der OTRS Business Solution™ Managed 5 schnell und ohne eigene IT-Ressourcen starten - Jetzt neue Features entdecken und bestellen
https://www.otrs.com/neu-in-otrs-business-solution-5-mobile-kommunikation-transparente-prozesse/?lang=de
> Am 11.02.2016 um 23:25 schrieb John O'Neill <john.oneill.ie@gmail.com>:
>
> Hi
>
> We have OTRS 5 in place at the moment, all is working well except for when we receive emails in from certain users who have the following footer in their emails
>
> Kind Regards / Mit freundlichen Grüßen / Freundliche Grüße / Saludos cordiales / Saygılarımla / Cordialement
>
>
>
> Were working on the assumption that the issue has something to do with the character set, our database is working in UTF8, with the following settings in my.cnf
>
> [client]
> default-character-set=utf8
>
>
> [mysqld]
> character-set-server=utf8
>
>
> The show variables statement shows the following
>
>
> SHOW VARIABLES LIKE "character_set_%";
> +--------------------------+----------------------------+
> | Variable_name | Value |
> +--------------------------+----------------------------+
> | character_set_client | utf8 |
> | character_set_connection | utf8 |
> | character_set_database | utf8 |
> | character_set_filesystem | binary |
> | character_set_results | utf8 |
> | character_set_server | utf8 |
> | character_set_system | utf8 |
> | character_sets_dir | /usr/share/mysql/charsets/ |
> +--------------------------+----------------------------+
>
> So it seems that everything is set to be UTF8 and as such should be able to handle the different character sets.
>
> Every time we get a mail in with the special characters we get the following error
>
> "There was an error executing Execute() in Kernel::System::Console::Command::Maint::PostMaster::MailAccountFetch: [Thu Feb 11 22:24:12 2016] otrs.Daemon.pl: DBD::mysql::db do failed: Incorrect string value: '\xC4\xB1lar\xC4...' for column 'a_body' at row 1 at /opt/otrs/Kernel/System/DB.pm line 449."
>
>
> I have run out of ideas now and was wondering if anyone might be able to suggest where I could go next, we are running otrs 5.0.3-01 on CentOS release 6.7 (Final)
>
>
> Many thanks,
> John
>
> ---------------------------------------------------------------------
> OTRS mailing list: otrs - Webpage: http://otrs.org/
> Archive: http://lists.otrs.org/pipermail/otrs
> To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs