[BlueOnyx:27279] Re: Moodle mysql_full_unicode_support

[Colin Jack]

Thanks Michael,


> 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.

No Collation in Operations tab, so will have a go from the CLI

Thanks for your help.

Kind regards

Colin