After migration to MySql 8 from 5.7 - Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLICIT) for operation '='

Asked Aug 04 '21 at 06:49

Active Aug 04 '21 at 06:49

Viewed 699 times

After migration of MySql from 5.7 to 8, I am getting the Illegal mix of collations exceptions. The same stored procedure works very fine in 5.7 version.

I have added the correct collation to the database, tables and to the table columns

See the images for more information.

Database:

Tables

I have added CharSet=utf8mb4; to my connection string. That didn't made any change.

Exception:

MySql.Data.MySqlClient.MySqlException (0x80004005): Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLICIT) for operation '=' at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)

asked Aug 04 '21 at 06:49

Bibin Gangadharan

Does this help you https://stackoverflow.com/questions/44027987/illegal-mix-of-collations-utf8mb4-unicode-ci-implicit-and-utf8mb4-general-ci ? – Ergest Basha Aug 04 '21 at 07:52
1

I converted all the table and table column collation to utf8mb4_0900_ai_ci. It started working – Bibin Gangadharan Aug 04 '21 at 18:42

After migration to MySql 8 from 5.7 - Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLICIT) for operation '='

0 Answers0