[wp-trac] [WordPress Trac] #37956: DB_COLLATE doesn't override $collate when defining utf8mb4_unicode_ci in wp-config

[WordPress Trac]

#37956: DB_COLLATE doesn't override $collate when defining utf8mb4_unicode_ci in
wp-config
--------------------------+----------------------
 Reporter:  MikeGillihan  |       Owner:
     Type:  defect (bug)  |      Status:  closed
 Priority:  normal        |   Milestone:
Component:  Database      |     Version:  4.6
 Severity:  normal        |  Resolution:  wontfix
 Keywords:                |     Focuses:
--------------------------+----------------------
Changes (by pento):

 * status:  new => closed
 * resolution:   => wontfix
 * milestone:  Awaiting Review =>


Comment:

 This behaviour is on purpose - if `DB_COLLATE` is defined as
 `utf8mb4_unicode_ci`, but the server supports `utf8mb4_unicode_520_ci`,
 it's better to use the latter, in much the same way as setting
 `DB_CHARSET` to `utf8` will be automatically upgraded to `utf8mb4` when
 possible.

 The workaround for this is to either have your development and production
 environments match, or to include a step in your data migration process to
 change the collation.

--
Ticket URL: <https://core.trac.wordpress.org/ticket/37956#comment:1>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform