otrs 3 with iis 7 and Microsoft sql

[spiderpig]

hi,

foreign letters are all in mess with this setup, i'm running otrs on another server with mysql and the foreing letters work fine.

any suggestions ?

thanx.

[spiderpig]

i was wondering if it could be the charset, i'm using utf-8 for otrs.
do i have to make some changes in the microsoft sql db ?
i'm using letters like ó and á that dosent show up right.

[spiderpig]

they dont show up right when i create user and receive email with this letters, so it must be the mssql ?

[zhakal]

For us to be able to use øæå and equivalent characters we added the following to Config.pm
$Self->{'DefaultCharset'} = 'iso-8859-1';

And the MSSQL

Collation: Danish_Norwegian_CI_AS

It can be used with UFT-8 but then you need to find a matching Collation in MSSQL.
The following might be the closest ones and should set correct input: Latin1_General_CI_AI or Latin1_General_CI_AS

[spiderpig]

Hi zhakal,

thanx for the reply, i put the charset in otrs to iso-8859-1 and it seems to work now, but not in the Agent Dashboard... hmm strange.
i see the tickets subject with messed up letters but when i open the ticket it works

[spiderpig]

Here is a screenshot from my dashboard, any suggestions ?