Statistics / GD::Text and UTF-8

Hi! We're running OTRS 2.0.4 on Debian Sarge with MySQL 4.1 (which defaults to latin1 on Debian) under Apache 2.0 as CGI. The system is using "swedish" as its locale (sv_SE.iso-8859-1). Our OTRS installation is Unicode-enabled using $Self->{'DefaultCharset'} = 'utf-8'; in the configuration file. However, we're having problems with Swedish characters in queue names when viewing statistics. Statistics --> New Tickets --> CSV yields a iso-8859-1 encoded file. (Shouldn't this be UTF-8?) Statistics --> New Tickets --> Graph yields a graph where the Swedish characters are replaced by their two strange iso-8859-1 character "counterparts" instead of one, correct character. Could GD::Text or the font be at fault here? Statistics --> New Tickets --> Printer yields a table with "correct" queue names. Mozilla shows the page as UTF-8 encoded, although I cannot find anything about this in the HTML page itself. Shouldn't the page specify the character set used? Or does OTRS supply this through a Content-Type header instead? I have tried setting LC_ALL=sv_SE.UTF-8 and LANG=sv_SE.UTF-8 for the CGI script, in case this would affect things, but that didn't change anything. The queue names in the database also show the two-strange-characters-counterparts, as all tables etc. are latin1 and obviously OTRS has tried stuffing UTF-8 data into those. (I couldn't find anything in the database scripts supplied with OTRS indicating that the tables are set up to be UTF-8. Perhaps this shouldn't matter if one interprets the data correctly...) I would be grateful for any insights regarding this. Many thanks in advance! Best regards, Björn

Hello Nils! Thank you for your reply! On Tue, 17 Jan 2006, Nils Breunese (Lemonbit Internet) wrote:
I am not an expert in this field, but maybe also Apache's AddDefaultCharset also has a say in this. What is that set to?
It is unset, so Apache shouldn't give any preferences there (I think it was removed from the default configs a couple of versions back as it always emitted this info, and wasn't just a "default"...). The graph, however, shouldn't be affected by this, I think (it is just an image). Best regards, Björn

Hi Björn, I'm not an expert on utf-8, but I set up our OTRS 2.0.4 also to use utf-8 and ran in the same problems like you. I did some dirty hacking and fixed the problem (I hope so). The OTRS-team knows about the problem and plans to fix it in further releases as far as I know. See http://bugs.otrs.org/show_bug.cgi?id=799 and espacially (in german) http://lists.otrs.org/pipermail/otrs-de/2005-December/005212.html to read how this problem can be fixed. If you need more advice (in english), let me know... Bye, Alex Björn Wiberg schrieb:
Hi!
We're running OTRS 2.0.4 on Debian Sarge with MySQL 4.1 (which defaults to latin1 on Debian) under Apache 2.0 as CGI. The system is using "swedish" as its locale (sv_SE.iso-8859-1).
Best regards, Björn

Hello Alexander! Thank you for your reply! On Wed, 18 Jan 2006, Alexander Scholler wrote:
See http://bugs.otrs.org/show_bug.cgi?id=799 and espacially (in german) http://lists.otrs.org/pipermail/otrs-de/2005-December/005212.html
Thanks! It seems that you have already covered all the details I wished for. I guess this means that we will wait for this to appear in future releases. Thanks again! Best regards, Björn
participants (3)
-
Alexander Scholler
-
Björn Wiberg
-
Nils Breunese (Lemonbit Internet)