is the mysql_full_unicode_support check is 100% sure ?

is the mysql_full_unicode_support check is 100% sure ?

by REMI PICARD (substitute) -
Number of replies: 2

hi,


i'm trying to solve the environnement check point of

I read the page https://docs.moodle.org/35/en/MySQL_full_unicode_support , it said that without that feature, all emojy and asian text will be over.


When i restore my database (from a migration), i create a database under uft8mb4, so i don't understand that issue.

i checked my sql dump file, and all asian characters are fine.  i also checked data in the mdu_user, and people with asian character are well stored and on the moodle front site, all asian character are displayed fine too.

so i don't understand why the point is on "check" and not on "OK" .


I checked my tables on phpmyadmin, on the right i have "utf8_general_ci",  is there the source of the problem (not haveing OK in statut environnement) ?

moodle tables list from phpmyadmin

best regards


Average of ratings: -
In reply to REMI PICARD (substitute)

Re: is the mysql_full_unicode_support check is 100% sure ?

by Emma Richardson -
Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Plugin developers

They should be on utf8mb4_unicode_ci

Average of ratings: -
In reply to REMI PICARD (substitute)

Re: is the mysql_full_unicode_support check is 100% sure ?

by Ken Task -
Picture of Particularly helpful Moodlers

Since you do have ssh into your shared server and assuming the DB user in your config.php file has abilities, there are some php scripts in code/admin/cli/ which will help with full unicode support.

mysql_collation.php
mysql_compressed_rows.php
mysql_engine.php

issued with no parameters passed will/should bring up a help page.

php mysql_collation.php is an example.

That also assumes that php issue above will find the php-cli for your sites version of PHP.

Here again ... shared hosting would restrict you from setting defaults in your DB server config file as those changes would affect all customers on that shared server.   Shared DB as well?

'SoS', Ken


Average of ratings: -