Thanks for very accurate response!
What you are seeing is a check ... but not a show stopper.
The bottom line questions:
1. do you **need** emojes? Of what true educational value do they have in instruction/teaching and learning? My take ... don't need.
2. are you going to offer a course in an Asian language. If not, don't need to attempt config to get enironment check all green with no yellow check warnings.
Now a word of caution ... dunno about 3.8 of Moodle nor what the road map says/shows for beyond. For now, am gonna guess Moodle HQ won't be that 'mean' and *require* ... if they do ... predict mass exodus!
As long as on a soapbox roll ...
Must say ... this sucks ...
"The SG customer service guys said that they "could" run the command for
me IF I could confirm exactly the command they should run."
Indicates that SG Shared hosting not a good fit for Moodle 3.7 and beyond.
But, SG is not alone ... was just helping a gentleman in Austrialia this weekend and he host on TMD ... well known hosting and generally good ... for WordPress's, Joomla's other ... just not for Moodle. Moodle is a 'different beast' and doesn't appear to becoming less so.
end soapbox ...
Anyhoo ... for those tech folks ... and they are gonna love this - *** IMPRESS UPON THEM TO DO A BACKUP OF THE DB BEFORE USING! ***
acquired from:
https://serverfault.com/questions/65043/alter-charset-and-collation-in-all-columns-in-all-tables-in-mysql
select CONCAT('alter table ',TABLE_SCHEMA,'.',TABLE_NAME,' charset=utf8;') from information_schema.TABLES WHERE TABLE_SCHEMA != 'information_schema' limit 10; select CONCAT('alter table ',TABLE_SCHEMA,'.',TABLE_NAME,' alter column ',COLUMN_NAME,' charset=utf8;') from information_schema.COLUMNS WHERE TABLE_SCHEMA != 'information_schema' limit 10;
and in above discussion ... this comment on above query:
If you feel good with the outcome of that, remove the limit clauses and save the output to an SQL script
mysql -B -N --host=prod-db1 --user=admin --password=secret -e "select CONCAT('alter table ',TABLE_SCHEMA,'.',TABLE_NAME,' charset=utf8;') from information_schema.TABLES WHERE TABLE_SCHEMA != 'information_schema'; select CONCAT('alter table ',TABLE_SCHEMA,'.',TABLE_NAME,' alter column ',COLUMN_NAME,' charset=utf8;') from information_schema.COLUMNS WHERE TABLE_SCHEMA != 'information_schema';" | mysql --host=prod-db1 --user=admin --password=secret
Depending upon the number of tables .. depending upon what you might have installed/used, the above command will generate a listing of alter commands ... **** ONE PER TABLE ***
Here's a clip ... (you can't use cause it was for another server! Do NOT try!) of what that looked like ... remember ... ONE table at a time.
ALTER TABLE demo_mdldb_test.mdldb_assessor_questions CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE demo_mdldb_test.mdldb_assessor_values CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE demo_mdldb_test.mdldb_assign CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE demo_mdldb_test.mdldb_assign_grades CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE demo_mdldb_test.mdldb_assign_plugin_config CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE demo_mdldb_test.mdldb_assign_submission CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE demo_mdldb_test.mdldb_assign_user_flags CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE demo_mdldb_test.mdldb_assign_user_mapping CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE demo_mdldb_test.mdldb_assignfeedback_comments CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE demo_mdldb_test.mdldb_assignfeedback_file CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE demo_mdldb_test.mdldb_assignment CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE demo_mdldb_test.mdldb_assignment_submissions CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE demo_mdldb_test.mdldb_assignment_upgrade CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE demo_mdldb_test.mdldb_assignsubmission_file CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE demo_mdldb_test.mdldb_assignsubmission_onlinetext CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;
I sat for about an hour and copied and pasted about 20 of those at a time into mysql> client prompt.
424 lines/commands like above ... pain in the ARSE!
Oh what fun that was!!!! BUT ... IT WORKED.
If you notice it's not the recommended utf8mb4 with utf8mb4_collations of any kind ... but utf8 and utf8_unicode_ci
Again ... the site I was working on doesn't care about emoj's nor do they plan to teach asian languages. So they will have to 'tolerate' ... ie, 'ignore', the checks. HELL, I can do that! We are more and more living in an imperfect world!
BUT ... again ... caution ... if Moodle HQ changes their minds ... if they do ... you might need to seek Dedicated VPS hosting and might have to hire a true DB admin to fix ... OR ... host with a Moodle Partner. (Hmmmm ... I wonder!) OR migrate what you can to Canvas/other LMS 'poison/evilness'. Oh, my! Maybe even Google Classroom!!!!
Do use the environment check before you do ANY upgrade to Moodle. Hopefully, that will stop a train wreck! :|
As anyone can see, this response not characteristic of the Moodle Borg ... and ponders things no one can know/tell nor project into the future.
'spirit of sharing', Ken
