Correct alphabetical order in Finnish

I’m currently building up a dictionary with the Dictionary add-on (which is very nice). But I came across a problem. I first thought it’s with the add-on, but after some testing, it seems to be with Concrete. (Core Version - 8.5.7)

When using alphabetical order in Dictionary – or with Page list – , all words under Ä are listed under A.
But the correct Finnish alphabet is a, b, c, d, e, f, g, h, i, j, k, l, m, n, o, p, q, r, s, t, u, v, w, x, y, z, å, ä, ö.
A and Ä are separate letters at the opposite ends of the alphabet.

How can I fix this? Installing the site in Finnish doesn’t help. The database is set to utf8mb4_unicode_ci.

Any suggestions? Help?

If you want proper sorting order in Finnish language, I believe you have to use utf8mb4_swedish_ci collation in your database. Though it’s general sql question, so you should propably ask other Scandinavian developers to confirm it.

utf8mb4_unicode_ci supports wide range of languages, but it sorts standard way, like aąábc etc…

THANK YOU, thank you, thank you…
That helped! I would not have figured that out myself.