-
- 169 Posts
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?
-
- 24,544 Posts
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).
-
- 169 Posts
Ah. My db is utf8_general_ci already. To switch to utf8_unicode_ci should not need the whole process?
-
- 24,544 Posts
I don't think so, but I could be wrong (hence the backup).
-
- 169 Posts
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.
-
- 24,544 Posts
Thanks, I just fixed the .zip file.
I'm glad it worked for you.