It lools like utf8mb4_unicode_520_ci implements a newer unicode collation standard, and fixes some shortcomings of current utf8mb4_unicode_ci (see wordpress link below).
Some sources:
* What the folks at wordpress say: #32105 (Database collate should be utf8mb4_unicode_520_ci) – WordPress Trac
* Stackexchange: MySQL Collation utf8_unicode differences - Database Administrators Stack Exchange
* MySQL :: WL#2673: Unicode Collation Algorithm new version (See right in-page tab)
* What the folks at provision module say: Set default collation to utf8mb4_unicode_520_ci
Use utf8mb4_unicode_520_ci as default collation if available.
TBD
None
None
None
| Comment | File | Size | Author |
|---|---|---|---|
| #15 | 2932820-6-13-interdiff.txt | 977 bytes | sharique |
| #13 | 2932820-use-utf8mb4_unicode_520_ci-collation-13.patch | 3.39 KB | sharique |
| #7 | 2932820-inerdiff-4-6.txt | 1.08 KB | sharique |
| #7 | 2932820-use-utf8mb4_unicode_520_ci-collation-6.patch | 3.15 KB | sharique |
Comments
Comment #2
geek-merlinComment #3
daffie commented+1 for me. Drupal is fully multilingual. Drupal uses utf8mb4_general_ci at the moment and that results in: "fails to implement all of the Unicode sorting rules, which will result in undesirable sorting in some situations, such as when using particular languages or characters." See discussion at http://stackoverflow.com/a/766996.
Comment #4
sharique commentedInitial patch, in testSchema ASCII string test is failing for me.
Comment #5
sharique commentedIf I'm correct we need MySql 5.6 for utf8mb4_unicode_520_ci .
Comment #7
sharique commentedLangcodeToAsciiUpdateTest is failing on permission denied for me, any suggestions. Permission in sites/simpletest are fine.
Comment #9
sharique commentedTests are failing because MySql 5.5 does not support 'utf8mb4_unicode_520_ci' collation.
Comment #10
sharique commentedI did some experiment using " Database::getConnection()->version();" method, to add checks for version but can't determine appropriate version to use, I'm running Maridb version 5.5.5-10.2.11-MariaDB, which support utf8mb4_unicode_520_ci, but Mysql 5.5 does not support it.
Comment #12
geek-merlin;-)
Comment #13
sharique commentedHere is updated patch.
Comment #15
sharique commentedThanks, Alex for advice, now we need to updated tests to support for both cases.
Comment #17
sharique commentedFor MySql 8 default collation is set to utf8mb4_0900_ai_ci, so I think this ticket is no more relevant, hence closing.