[BlueOnyx:27278] Re: Moodle mysql_full_unicode_support

[Michael Stauber]

Hi Colin,

> Can someone please suggest the best way to change the character set on the Moodle database?
> Running on MariaDB 10.5.13 on 5210R
 >
 > it requires mysql_full_unicode_support

To me that sounds as if Moodle requires a specific character set 
(utf8mb4) and collation (utf8mb4_unicode_ci) to fully support Unicode 
characters.

I'd do a backup of the SQL database first (via the GUI or phpMyAdmin) 
and then you could change it like this from within a MySQL shell:

mysql -u root -p

USE moodle_db_name;
ALTER DATABASE moodle_db_name CHARACTER SET utf8mb4 COLLATE 
utf8mb4_unicode_ci;

 > I can just make the change on that database from the phpMyAdmin?

Yeah, that ought to be possible. Open phpMyAdmin, find the database in 
question and then click on the "Operations" tab. At the bottom where it 
says "Collation" you have the option to change it.

-- 
With best regards

Michael Stauber