Error: Illegal mix of collations

PHPMaker General Discussion (PHPMaker)
1

hi,i viewlist where i activate the quick search (from a VIEW table).
when i perform a quicksearch with only one checked field, it works fine.
when i activate many fields (like 2 varchar) then i got this error that appears in the notification (top right on the screen) :Failed to execute SQL. Error: Illegal mix of collations (utf8mb4_unicode_ci,COERCIBLE) and (utf8mb4_general_ci,COERCIBLE) for operation ‘like’ (1267).any infos of that problem ? i use phpmaker 2020.9Best regards

2

You may check the CREATE TABLE statement of the table in your MySQL manager, make sure the collation of all fields are consistent as, for example, utf8mb4_unicode_ci.Note: From MySQL 8.0, utf8mb4 is the default character set, and the default collation for utf8mb4 is utf8mb4_0900_ai_ci.

3

hi,you right !
thanks to you, i discovered i have both utf8mb4_general_ci and utf8mb4_unicode_ci in the field which should not happend. i will investigate why…Have a good day

4

hi,just a little word to say you’ve got right !
once i unify the different charset, the problem deasappears and the query runs fine !thank you !