Defect #2838
closed
Swedish chars get mangled in issue when added via email
0%
Description
Swedish chars (Å,Ä and Ö) gets replaced with 奪 辰 and 旦 when added from email.
Raw sample of a mail:
MIME-Version: 1.0 From: supportform@domain.se To: support@domain.se Date: 23 Feb 2009 17:31:39 +0100 Subject: =?utf-8?B?w4XDhMOWIGkgYsO2cmphdCAodGVzdCBudW1tZXIgMjAp?= Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: base64 U3ZlbnNrYSB0ZWNrZW4gaSBiw7ZyamFuIGF2IHN1YmplY3QNCg0KaHR0cDovL3d3dy5uZXRy ZWxhdGlvbnMuc2Uvc3VwcG9ydC9hcmVuZGVuL25ldHJlbGF0aW9ucy8wOTAyMjMtMTczMTM5 LWFhby1pLWJvcmphdC10ZXN0LW51bW1lci0yMC8NCg0KUHJvamVjdDoga29udDUwMDENClBy aW9yaXRldDogS3JpdGlza3Q=
Platform version information¶
MySQL: 5.0.51a-3ubuntu5.4-log
Ruby: ruby 1.8.6 (2007-09-24 patchlevel 111) [i486-linux]
Rails: Rails 2.2.2
Redmine: Redmine 0.8.1.stable.2521
Somewhat related to #2814
Files
Related issues
Updated by Jean-Philippe Lang over 15 years ago
- File swedish.png swedish.png added
I don't have this problem. Here is what I get when running rake redmine:email:read project=redmine < email.txt
Does your database encoding properly set to UTF8 ?
Updated by Fredrik Frodlund over 15 years ago
I believe so.
- Default Character Set: utf8
- Default Collation: utf8_swedish_ci
This worked ok before, so I just bluntly assumed that something changed in an update. :)
Updated by Jean-Philippe Lang over 15 years ago
I don't see any change to the mail handler that could have affected this behaviour.
Do you know which revision was working ok for you before?
Updated by Fredrik Frodlund over 15 years ago
Sorry, no. It was back in the 0.7 branch.
Updated by Fredrik Frodlund over 15 years ago
I also noticed that the chars only gets mangled in the subject, not in the body.
Updated by hell hunter over 15 years ago
Fredrik Frodlund wrote:
I also noticed that the chars only gets mangled in the subject, not in the body.
Yes, I can confirm this for german "Umlaut"s in the subject. body works perfectly...
Cheers, Antonino
Updated by Fredrik Frodlund over 15 years ago
I just did a restart of the Ruby-application after a minor update to the latest revision (r2594) and all of a sudden, the chars didn't get mangled! However, after about an hour the problem re-emerged again. This is really weird!
Updated by Fredrik Frodlund over 15 years ago
Is there any more info that I can provide that will assist in the solving of this issue?
Updated by Fredrik Frodlund over 15 years ago
- Status changed from New to Resolved
This seems to resolved as of r2757. :)
Updated by Fredrik Frodlund over 15 years ago
Seems that this was not resolved after all. It was the same situation as before (a restart of the Ruby application fixed the error temporarily).
Updated by Kolja K. about 15 years ago
Same problem here (0.9 trunk). After some time of running the server, non ascii chars in the subject of mail generated tickets get mangled. Please reopen this issue.
Updated by Fredrik Frodlund about 15 years ago
Kolja K. wrote:
Same problem here (0.9 trunk). After some time of running the server, non ascii chars in the subject of mail generated tickets get mangled. Please reopen this issue.
The bug is still present and another issue was reported by me; #3717.
Updated by Kolja K. about 15 years ago
Update: We've switched the MySQL table encoding from swedish_latin1 to utf8 and so far everything's working.
Updated by Jean-Philippe Lang almost 15 years ago
- Category changed from Email notifications to Email receiving
Updated by Kolja K. almost 15 years ago
The problem persists, even if you switch to another table encoding. Pls reopen this issue.
Updated by Fredrik Frodlund almost 15 years ago
Please check #3717 instead. Same issue.
Updated by Jean-Philippe Lang almost 15 years ago
- Status changed from Resolved to Closed
- Resolution set to Duplicate