Incoming mail parsing issue with non-Ascii characters
We track issues with IMAP mail:
rake -f /usr/share/redmine/Rakefile redmine:email:receive_imap RAILS_ENV="production" host=myhost ssl=true port=993 username=user password=password project=development tracker=Error allow_override=all move_on_success=Read move_on_failure=Error unknown_user=accept no_permission_check=1 --trace
This works fine if all characters in the email are ASCII. Now we have a customer in Poland. Whenever they write text like "szczegółowy opis błędu", the mail will be moved to "Error".
I am not able to track the issue further, since the trace looks fine:
Invoke redmine:email:receive_imap (first_time)
Invoke environment (first_time)
How could the parser be made more tolerant to these characters?
Redmine version 3.2.1.stable
Ruby version 2.3.1-p112 (2016-04-26) [x86_64-linux-gnu]
Rails version 18.104.22.168
Database adapter Mysql2
The issue is with the UTF8 character set in mysql.
To resolve the issue, see: