Yes,
I used Ken's suggestion in another post: "
There is a command line script in admin/cli/ called mysql_collation.php that will convert all tables and their columns to collation provided the script.
cd /path/to/moodle/code/admin/cli/
php mysql_collation.php [ENTER]
will show you the help screen and how to pass parameter to do the conversions.
Also, the recommended collation is utf8mb4_unicode_ci
I used Ken's suggestion in another post: "
There is a command line script in admin/cli/ called mysql_collation.php that will convert all tables and their columns to collation provided the script.
cd /path/to/moodle/code/admin/cli/
php mysql_collation.php [ENTER]
will show you the help screen and how to pass parameter to do the conversions.
Also, the recommended collation is utf8mb4_unicode_ci