“Error illegal mix of collations…” despite I changed all the tables to utf8_unicode_ci

Using my Dolibarr
, , ,
1

Hi,

I get the notorious Error Illegal mix of collations (utf8mb4_0900_ai_ci,IMPLICIT) and (utf8_unicode_ci,COERCIBLE) for operation ‘=’

Using Adminer I edited the database to utf8_unicode_ci but I still get the same error.

I even tried the /install/repair.php?force_utf8_on_tables=confirmed solution but then I got Error Incorrect string value: ‹ \xC3\xE2\x80\xA6 -… › for column ‹ label_operation › at row 1

I’m running Dolibarr v14.05 on Ubuntu 21.10 in a virtual machine. So I recovered the last snapshot before the “/install/repair.php?force_utf8_on_tables=confirmed” and back to Error Illegal mix of collations.

Thanks for your help

Michael

2

Hi, did you check the conf file also?