Re: [otrs] OTRS Special Characters

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-tr...

Am 11.02.2016 um 23:25 schrieb John O'Neill :

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