You mean you have not converted the database to utf8mb4 yet?
If true no wonder the question
I updated the db to utf8mb4 a few months ago. More recently, the db was upgraded to 8.0, and I have confirmed that all tables are utf8mb4. Yet the problem persists.
SELECT DEFAULT_CHARACTER_SET_NAME, DEFAULT_COLLATION_NAME, COUNT(0) AS COUNT FROM information_schema.SCHEMATA GROUP BY DEFAULT_CHARACTER_SET_NAME, DEFAULT_COLLATION_NAME;
DEFAULT_CHARACTER_SET_NAME DEFAULT_COLLATION_NAME COUNT
utf8mb3 utf8mb3_general_ci 2
latin1 latin1_swedish_ci 1
utf8mb4 utf8mb4_general_ci
SELECT TABLE_SCHEMA, TABLE_NAME, TABLE_COLLATION FROM information_schema.TABLES WHERE TABLE_COLLATION IS NOT NULL AND TABLE_COLLATION NOT LIKE '%utf8%';
0 row(s) affected by your query.
SELECT CHARACTER_SET_NAME, COLLATION_NAME, COUNT(0) AS COUNT FROM information_schema.COLUMNS WHERE CHARACTER_SET_NAME IS NOT NULL AND COLLATION_NAME IS NOT NULL GROUP BY CHARACTER_SET_NAME, COLLATION_NAME;
CHARACTER_SET_NAME COLLATION_NAME COUNT
utf8mb3 utf8mb3_general_ci 212
utf8mb3 utf8mb3_bin 155
utf8mb3 utf8mb3_tolower_ci 19
utf8mb4 utf8mb4_0900_ai_ci 14
utf8mb4 utf8mb4_general_ci 270
ascii ascii_general_ci 4
utf8mb4 utf8mb4_bin
There are four databases. The test db is a leftover that I should probably drop. It's the one that's inlatin1_swedish_ci 1
nformation_schema
performance_schema
test
ubbthreads
