How to Check Your WordPress Database Charset and Collation
To check a WordPress database’s charset and collation, run wp db query "SELECT @@character_set_database, @@collation_database;" for the database default, then query information_schema.TABLES for each table, because tables can differ from the default. A modern site should use utf8mb4, with…