Reply To: Scandinavian Alphabet

10/03/2016 at 9:31 am #394024
Steven Zahm
Keymaster

@ Ulrike

When Connections is installed it uses the database collation character set that WordPress is set to. If your was set to the correct language when installing WordPress and Connections, it’ll default to utf8mb4_general_ci. To change this you will need to log into your webhost control panel and use the phpMyAdmin app to change the collation to utf8mb4_{language}_ci, choosing the language option that best suits Scandinavian. After you make this change, the alpha will be sorted correctly. I think you want to choose the utf8mb4_swedish_ci option.

Here’s a link I found after a quick search that walks you through changing the collation. On you webhost the screens may look a little different but the steps are the same. Do not change the character set, only change the collation.

https://mediatemple.net/community/products/dv/204403914/default-mysql-character-set-and-collation

You should also configure WordPress to use the proper collation too.

Hope this helps!