How to convert all tables in database to one collation?

Published on Nov, 26 2024 1 min read 1 comments

#database #collation #mysql

I'm getting error:

Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='"

I tried changing both tables manually to utf8_general_ci,IMPLICIT but I'm still getting the error.

Is there a way to convert all tables to utf8_general_ci,IMPLICIT and be done with it?

1 Answers

Mahabubur Rahman Nov 26, 2024 - 05:46 AM