As of commit 4ed1267 (see https://www.drupal.org/node/2764111), default collation is currently set to utf8mb4_general_ci which "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

This patch changes default collation to utf8mb4_unicode_520_ci which is based on UCA 5.2.0. See https://dev.mysql.com/doc/refman/5.6/en/charset-collation-names.html

CommentFileSizeAuthor
#2 utf8mb4_unicode_520_ci-2792409-2.patch1.68 KBbwaindwain
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

bwaindwain created an issue. See original summary.

bwaindwain’s picture

bwaindwain CreditAttribution: bwaindwain as a volunteer commented
Status: Active » Needs review
FileSize
utf8mb4_unicode_520_ci-2792409-2.patch1.68 KB
colan’s picture

colan
he/him
Primary language English
Location Toronto 🇨🇦
CreditAttribution: colan at Colan Schwartz Consulting commented
Related issues: +#2764111: Support for utf8mb4
helmo’s picture

helmo CreditAttribution: helmo as a volunteer and at Initfour websolutions for Aegir Cooperative commented

I'd love to improve this ... but would this not add more confusion? Drupal core 7 and 8 still seem to default to/advise/are tested with 'utf8mb4_general_ci'.

Is there a core issue about this?

colan’s picture

colan
he/him
Primary language English
Location Toronto 🇨🇦
CreditAttribution: colan at Colan Schwartz Consulting commented
Status: Needs review » Postponed (maintainer needs more info)

Agreed. Please open an issue in Drupal core (as I couldn't find one), and add it as related here. We should be doing what's happening there as it's upstream for us.

geek-merlin’s picture

geek-merlin
they/omg
Primary language German
Location Freiburg, Germany
CreditAttribution: geek-merlin at MachbarMacher commented
Related issues: +#2932820: Use utf8mb4_unicode_520_ci as default collation