Support German umlauts on Linux?

[bayerex]

Hi all,

Since migrating to Ubuntu 12.04 certain pages are displaying the German umlauts incorrectly e.g.

sshot-1.png

sshot-2.png

I've checked that the files under /otrs are in UTF-8 format

This is my server's locale:

Code: Select all

$ locale
LANG=en_GB.UTF-8
LANGUAGE=en_GB:en
LC_CTYPE="en_GB.UTF-8"
LC_NUMERIC="en_GB.UTF-8"
LC_TIME="en_GB.UTF-8"
LC_COLLATE="en_GB.UTF-8"
LC_MONETARY="en_GB.UTF-8"
LC_MESSAGES="en_GB.UTF-8"
LC_PAPER="en_GB.UTF-8"
LC_NAME="en_GB.UTF-8"
LC_ADDRESS="en_GB.UTF-8"
LC_TELEPHONE="en_GB.UTF-8"
LC_MEASUREMENT="en_GB.UTF-8"
LC_IDENTIFICATION="en_GB.UTF-8"
LC_ALL=

Have tried putting this in my /etc/apache2/httpd.conf but it hasn't made any difference

DefaultLanguage de
LanguagePriority de en ca cs da el eo es et fr he hr it ja ko ltz nl nn no pl pt pt-BR ru sv zh-CN zh-TW
AddDefaultCharset ISO-8859-1

How can I fix this?

Many thanks in advance

[wurzel]

Hi,

did you migrate from an pevious version of OTRS?

You should have DB in utf-8. Perhaps you have exported/imported in non-utf8 format. Then:
dump database, sed your wrong-format into utf8

restore, and you should be fine.

But: Just from screenshot, you can not see, where the error is. What sais Support Module?

Flo

[bayerex]

Hi,

did you migrate from an pevious version of OTRS?

You should have DB in utf-8. Perhaps you have exported/imported in non-utf8 format. Then:
dump database, sed your wrong-format into utf8

restore, and you should be fine.

But: Just from screenshot, you can not see, where the error is. What sais Support Module?

Flo

Yes I created a database in Phpmyadmin ready to import my Windows3.1.6 database before upgrading to 3.2.7. I chose the defaults which I think is where I went wrong because most of the tables came out UTF-8_general_ci format but others are for some reason latin1_swedish_ci. The process_id table from the Windows3.1.6 database has become corrupt anyway and failed to export so I shall deal with all this and get back to you! Thanks for the advice.

[bayerex]

I've started again with my database now and every table is in UTF-8 format but the problem remains. I also run SugarCRM on the same server and that has no problems displaying German umlauts.

Any other ideas how I could fix this?