Robert Trevellyan

What this means is:

1. Create a .php file and paste in the script.
2. Edit the script to replace the placeholders with information specific to your server.
3. Upload the script to your server.
4. Enter the URL of the script in your browser to run it.
5. Delete the script from your server.
6. Use your favorite migration process to migrate your installation.

You’re welcome, I copied it from hkasera’s answer to “How to change collation of database, table, column?” on stackoverflow.com.

In which version? I don’t see a release more recent than my report.

For anyone needing a workaround, you can run this php script on your existing installation before migration (posted on stackoverflow.com by hkasera):

<?php
$con = mysql_connect('localhost','user','password');
if(!$con) { echo "Cannot connect to the database ";die();}
  mysql_select_db('dbname');
  $result=mysql_query('show tables');
  while($tables = mysql_fetch_array($result)) {
    foreach ($tables as $key => $value) {
      mysql_query("ALTER TABLE $value CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci");
    }}
  echo "The collation of your database has been successfully changed!";
  ?>

That looks promising, I will talk to our client about Relevanssi Premium.