While upgrading Moodle on one of our sites, There was a warning, with a link to https://docs.moodle.org/311/en/MySQL_full_unicode_support
The admin of the site reported,
Received an error message, "Error writing to database" on trying to add an emoji.
Though emojis were not so important, Indian language support was required.
On checking the collations, found that the db used
Default Charset = utf8 and
Default Collation = utf8_general_ci
just like another test site of ours, and that copy-pasting Indian language text was working -
ఈ వచనం మన సైట్లో తెలుగును పరీక్షించడానికి.
So I did not change the collation to utf8mb4_unicode_ci as suggested in the Moodle documentation in the link at the beginning of this post, since this is a potentially dangerous operation, and can take a long time and can break things, so I would need to take precautions like making a backup, a rollback plan and so on.
No comments:
Post a Comment