Hi Neil,

The templates are stored in the database - is the db charset also utf-8? MySQL can be a bitch when you want to convert charsets in the tables. Last time I did it, I had to create a dump with one charset, drop the database, recreate it in utf-8 and restore the dump. Also, I had to change all "create table"-statements in the dump to create the tables in utf-8.

I don't know if there is an easier way (now), but if you only have a few templates, you should consider correcting them inside OTRS Admin and then worry about the database at a later point in life.

Lars

From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Neil Simpson
Sent: Tuesday, August 23, 2011 2:55 PM
To: otrs@otrs.org
Subject: [otrs] Template char set issues

Hello,

Just upgraded from 2.4.7 and now all self-made templates do not show correctly. I have everything set to UTF-8 and yet i still have strange characters instead of the correct character.

I have tried setting the UTF-8 options manually in each template/form but this does not effect it.

the "page source" shows in the header " <meta http-equiv="Content-type" content="text/html;charset=utf-8" /> " so it should be set.

if i manually paste some french/german text into the text field it is shown correctly, only if i use a template does it not show correctly.

httpd.conf is default UTF-8.

running out of ideas.

thanks for any guidance.

Neil