1

I display a list of entries using

orderby="title"
sort="asc"

But titles starting with the Swedish character "Å" and "Ä" is sorted before "A" - and it should be last in the list. Like this:

... X Y Z Å Ä Ö

Is there a way (hack?) to solve this?

Regards, Magnus

2 Answers 2

3

Risking tooting my own horn here, but Low Alphabet will let you generate alphabetical lists and will ignore diacritics. If you don't want to use an add-on, you probably need to resort to PHP in your template.

2

In my experience (working with Norwegian characters) you need to set the MySQL collation to "utf8_danish_ci". Admittedly counter-intuitive when working with Swedish content, but if it works...

2
  • Thanks. Strange, but I will try this. Apr 5, 2013 at 13:10
  • That worked, @Svale! I changed the collation to utf8_swedish_ci and also created a new database with the default collation set to swedish. But, I also changed in database.php (in config) to: $db['expressionengine']['dbcollat'] = 'utf8_swedish_ci'; Apr 16, 2013 at 6:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.