Inside your Moodle code, run the CLI script admin/cli/mysql_collation.php - this can alter the collation for each of your Moodle DB tables.
Obviously, take a backup before making such wide-ranging changes to a production database.
General developer forum
DB special characters problem
This discussion has been locked so you can no longer reply to it.