Sort articles with special characters

I do use the sort function of articles, but the sorting does not reflect german special characters. E.g this is what I get

1. ko
2. ku
3. kö

but I should get

1. ko
2. kö
3. ku

Is there any way to customize the sorting routine. Did not find anything.

No ideas on that?

Well, it has to do with the sortby configuration (which is actually basic). If I put LOWER(pagetitle) as sortby I do get a sort ignoring the upper and lower case. But thats half the way. What I am looking for is something like natsort(), natural sorting in php. I am not sure about about how sortby works, but it seem to do the sorting direcly in sql. Is there any way to configure the sortby for natural order?

Check the DB tables and their text fields in PhpMyAdmin. I would expect the sorting to work correctly if they are all utf8/utf8_unicode_ci.

I would back up the database before making any changes. See this if there are Latin1 entries: http://bobsguides.com/convert-db-utf8.html (you might have to change utf8_general_ci to utf8_unicode_ci in the script).

Ah. My db is utf8_general_ci already. To switch to utf8_unicode_ci should not need the whole process?

I don't think so, but I could be wrong (hence the backup).

Thanks Bob. Your script worked fine for me and solved my problem.

By the way, your guides link provides just the config files. Found the script at github.

Thanks, I just fixed the .zip file.

I'm glad it worked for you.