Ilegal Mix of Collections

Scriptcase 9
#1

Hi, when performing an advanced search on a grid, I get an ‘Illegal mix of collations’ error. However, it only occurs when searching a specific varchar field, as searching a date field does not generate any errors. The reason may be that the varchar field has a collation of utf8mb4_spanish_ci while the table has a collation of utf8mb4_general_ci.

Is there any way to fix it?

#2

Pretty much the only way to deal with it is make them all the same. I went through every table and made sure they were the same character set and collation or this will pop up. You can convert an entire table at a time with ALTER TABLE TABLENAME CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci (or whichever you want)

1 Like