Reply To: READ FIRST: Translating Connections

02/11/2015 at 5:34 pm #319108
Steven Zahm
Keymaster

@ lenaW

The order would be determined by the collation of the database. Connections will use the collation as defined by WordPress which I believe by default is utf8_general_ci.

http://codex.wordpress.org/Editing_wp-config.php#Database_collation

Or, if no value is set, will use the databases default.

My guess is that one or the other defaulted to utf8_general_ci.

What you need to do is use phpMyAdmin and change the collation of the connections table to the utf8_swedish_ci. Here’s a link that has step by step with screenshots:

http://kb.mediatemple.net/questions/138/Default+MySQL+character+set+and+collation#gs

The relevant instructions start at step 9, unless you want to change the default for the whole database (only affects new tables), then start at step one.

Hope that helps!