...
Code Block | ||||
---|---|---|---|---|
| ||||
SELECT TABLE_CATALOG,TABLE_SCHEMA,TABLE_NAME,COLUMN_NAME,COLLATION_NAME,CHARACTER_SET_NAME from information_schema.columns where CHARACTER_SET_NAME != 'utf8utf8mb4'; |
Code Block | ||||
---|---|---|---|---|
| ||||
ALTER DATABASE <database_name> CONVERT TO CHARACTER SET utf8utf8mb4 COLLATE utf8utf8mb4_unicode_ci; |
Additional Errors produced due the missing charset:
...