...
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:
Code Block |
---|
SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=', query was: |