Japan characters in email fields crushes OTRS mail dispatcher

jester · Post by **jester** » 22 Oct 2015, 10:18

Hi everyone,

I've found an interesting behaviour in OTRS 5 RC1. I have a mailbox tied up with an OTRS queue. Everything works fine until someone sends an email with Japan characters in from field - that message will not be dispatched and a error log entry will be generated. Screenshot of error meesage is in the attachment.

Anyone have an idea how to handle this? Thanks in advance.

jojo · Post by **jojo** » 22 Oct 2015, 10:35

could you try with OTRS 5.0.1?

jester · Post by **jester** » 22 Oct 2015, 11:31

I found the reason - there was non-utf8 collation in database tables. Changed to utf8 everywhere and it works like a charm.

Henry · Post by **Henry** » 04 Jan 2016, 19:57

Hi Jester,
I've got the same problem here. Did you convert all of your old data to utf8 or just change the database so that new tickets were created in utf8? Did you follow a particular set of instructions? There seem to be quite a few different suggestions for changing the characterset of a MySQL database.

Thanks,
Alan

Znuny Open Source Ticketsystem

Japan characters in email fields crushes OTRS mail dispatcher

Japan characters in email fields crushes OTRS mail dispatcher

Re: Japan characters in email fields crushes OTRS mail dispatcher

Re: Japan characters in email fields crushes OTRS mail dispatcher

Re: Japan characters in email fields crushes OTRS mail dispatcher