[wp-trac] [WordPress Trac] #45697: Database: Upgrading field collations

[WordPress Trac]

#45697: Database: Upgrading field collations
-------------------------+-----------------------------
 Reporter:  pento        |       Owner:  (none)
     Type:  enhancement  |      Status:  new
 Priority:  normal       |   Milestone:  Future Release
Component:  Database     |     Version:
 Severity:  normal       |  Resolution:
 Keywords:               |     Focuses:
-------------------------+-----------------------------

Comment (by pento):

 That's a good thing to take into account, thanks @knutsp.

 `utf8mb4_0900_ai_ci` does accent-insensitive ("ai") sorting, as well as
 case insensitive ("ci") sorting.

 For language-specific sorting, there are language-specific collations (eg,
 `utf8mb4_sv_0900_ai_ci`), as well as accent and case sensitive collations
 (eg, `utf8mb4_sv_0900_as_cs`). Any upgrade process should take these into
 account.

 Ref: https://dev.mysql.com/doc/refman/8.0/en/charset-mysql.html

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