Package: otrs
Version: 2.0.4p01-1
Severity: normal
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.
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?
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.
The following bug and posting are related, however, none of this is mentioned
in the OTRS TODO list (/usr/share/doc/otrs/TODO.gz):
http://bugs.otrs.org/show_bug.cgi?id=799
http://lists.otrs.org/pipermail/otrs-de/2005-December/005212.html
As those point out, OTRS should really go "all the way" with UTF-8 if Unicode
support is chosen at installation time; i.e. create tables with UTF-8 character
set/collation, use SET NAMES when communicating
with the database server, handle any conversion needed for the usage of data
extracted from the database (e.g. GD::Text for the statistics graphs?) etc.
Best regards,
Björn
-- System Information:
Debian Release: 3.1
Architecture: i386 (i686)
Kernel: Linux 2.6.14.3.051125-01-dell-custom
Locale: LANG=swedish, LC_CTYPE=swedish (charmap=ISO-8859-1) (ignored: LC_ALL
set to swedish)
Versions of packages otrs depends on:
ii apache2 2.0.55-3-custom1 next generation, scalable, extenda
ii apache2-mpm-prefork [ap 2.0.55-3-custom1 traditional model for Apache2
ii libauthen-sasl-perl 2.08-2 Authen::SASL - SASL Authentication
ii libdate-pcalc-perl 1.2-2 Perl module for Gregorian calendar
ii libdbi-perl 1.46-6 Perl5 database interface by Tim Bu
ii libemail-valid-perl 0.15-1 Check validity of Internet email a
ii libio-stringy-perl 2.110-1 Perl5 modules for IO from scalars
ii libmailtools-perl 1.62-1 Manipulate email in perl programs
ii libmime-perl 5.417-1 Perl5 modules for MIME-compliant m
ii perl 5.8.4-8 Larry Wall's Practical Extraction
-- no debconf information
