[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 JavierCasares):

 Setting a charset is important and will be great or having a universal one
 (like "utf8mb4") because, right now, "utf8" and "utf8mb3" are confusing
 between versions.

 About the collation, each database have their own. For example, default
 collations:

 - MySQL / UTF8mb3: utf8_general_ci
 - MariaDB / UTF8mb3: utf8mb3_general_ci
 - MySQL / UTF8mb4: utf8mb4_0900_ai_ci
 - MariaDB / UTF8mb4: utf8mb4_general_ci

 Also, about the collation... Should we explain (like at Sie Health) that,
 if you write in Spanish, may be better to have something like
 utf8mb4_spanish_ci so you have order like "...m, n, ñ, o, p..."?

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