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