Hello!

We earlier had only $Self->{DefaultCharset} = 'utf-8'; but a default of latin1 for the MySQL database, and the OTRS database was created using latin1, and hence all tables had collation latin1.

We changed the default character set of the database to UTF-8 (for the future) and changed the collation of every single OTRS table to utf8_general_ci.

This solved the problem of Swedish characters not showing correctly in the Statistics graphs.

However, exporting as a comma separated value (CSV) file still yields the Swedish characters in iso-8859-1, but that is a minor issue.

Best regards,
Björn Wiberg
Uppsala University
IT Support Department

Reply via email to