Open main menu

Changes

no edit summary
<source lang="mysql">
SHOW VARIABLES WHERE Variable_name LIKE 'character\_set\_character_set_%' OR Variable_name LIKE 'collation%';
</source>
Here's a [https://stackoverflow.com/questions/54885178/whats-the-difference-between-utf8-unicode-ci-and-utf8mb4-0900-ai-ci Stack Overflow question + answer] that explains the different encodings (byte mappings) and collations (sorting rules) and why it _might_ matter to you. The newest collations only really matter if you're trying to chase the long tail of performance optimizations.
BTW, the answer is by Rick James (not the singer - the [[MySQL#Experts|database expert]])
From WMF, I see [https://gerrit.wikimedia.org/r/plugins/gitiles/operations/puppet/+blame/0adab4be323405345c3c63428747c12e3ad4aea2/modules/galera/templates/server.cnf.erb this puppet template for the galera configuration], updated on 2020-06-11 specifying