MySQL Full Unicode Support

Firstly, to check that which tables need to change the char set.

SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA= "moodle" AND TABLE_TYPE="BASE TABLE" AND `TABLE_COLLATION` <> "utf8mb4_unicode_ci"

And then, generate the SQL which need to be executed.

SELECT CONCAT('ALTER TABLE `', TABLE_NAME,'` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;') AS mySQL FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA= "moodle" AND TABLE_TYPE="BASE TABLE" AND `TABLE_COLLATION` <> "utf8mb4_unicode_ci"

Some useful SQL

Alter the Database char set

ALTER DATABASE moodle CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;

Alter the Specific Table char set

ALTER TABLE mdl_zoom_meeting_participants CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

You May Encounter with errors

ALTER TABLE `mdl_user_devices` CHANGE `pushid` `pushid` VARCHAR(191) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '';

Moodle MySQL

Moodle MySQL Full Unicode Support