Sorting by swedish alphabet?

[vkandersv]

Hi,

I cant really figure out this,

We have a couple of tickettypes that we have renamed to swedish so that our users will be happy;

Incident
Incident::Katastrof
Problem
Ändring
Ändring::Avbruten
Ändringsbegäran


My problem is that OTRS show this like

Ändring
Ändring::Avbruten
Ändringsbegäran
Incident
Problem

ie it puts Ä in same collation position as A, how can i change this?

[vkandersv]

ive got this problem in the iPhone also

[jojo]

you can not change this...

[vkandersv]

Because?

Ive got the soruce for everything except the iphone app so of course i can change this. just woundering if someone else have tried before.

[jojo]

changing code will prevent you from easy updating

[vkandersv]

yes of course.

[ferrosti]

I do not have the time to get deeper into this, so I just give a hint:
You could set mySQLs collation to your needs. In case these values are sorted due to 'ORDER BY' instead of 'sort()' in perl you will get what you want.