Loading...

XML

Word

Printable

Affected Branches:
MOODLE_404_STABLE
Pull from Repository:
https://github.com/micaherne/moodle.git
Pull Main Branch:
MDL-81837-main
Pull Main Diff URL:
https://github.com/moodle/moodle/compare/main...micaherne:moodle:MDL-81837-main
Testing Instructions:
- Run the full Moodle unit tests with MySQL, with collation set to utf8mb4_0900_as_cs
- Confirm that all tests pass
Pre-check results:
Hide

Code verified against automated checks.

Checked MDL-81837 using repository: https://github.com/micaherne/moodle.git

main (0 errors / 0 warnings) [branch: MDL-81837-main | CI Job]

_{More information about this report}

Built on: Mon Feb 17 09:07:45 AM UTC 2025
Show
Code verified against automated checks. Checked MDL-81837 using repository: https://github.com/micaherne/moodle.git main (0 errors / 0 warnings) [branch: MDL-81837-main | CI Job ] More information about this report Built on: Mon Feb 17 09:07:45 AM UTC 2025

In MySQL 8.0.1, a number of new collations were introduced, which are case and accent sensitive: https://dev.mysql.com/blog-archive/mysql-8-0-1-accent-and-case-sensitive-collations-for-utf8mb4/

It would be good if Moodle could support these as:

it would make MySQL behave consistently with Postgres
there are known core unit test failures when using the recommended production collation - utf8mb4_unicode_ci - where the recommended "solution" is to run the tests with the utf8mb4_bin collation, which arguably invalidates the test results

will help resolve

MDL-36208 Case-insensitive collations in the database cause problems and should be changed to case-sensitive