Editing issue : Illegal mix of collations utf8_unicode_ci vs utf8_general_ci

[DLJonsson]

Hi Dadabik Forum:

When editing we started getting this error.

General error: 1267 Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='

Results looking at the SQL Variables are listed below.

* Please remind what is the preferred Unicode for Dadabik?

* Any other suggestions appreciated.

Thanks





SQL comand
SHOW VARIABLES WHERE Variable_name LIKE ("Collation%") or Variable_name LIKE ("%char%")
Returns the following .
character_set_results
character_sets_dir /usr/share/mysql/charsets/
character_set_filesystem binary
character_set_client utf8
character_set_connection utf8
character_set_database utf8
character_set_server utf8
character_set_system utf8
collation_connection utf8_general_ci
collation_database utf8_unicode_ci
collation_server utf8_unicode_ci

 

[eugenio]

Hello,
as a character set, I currently use utf8mb4 for my projects and I recommend it; about the collation, there isn't a preferred collation for dadabik, you get such errors because the tables involved in your queries used a different collations, you have to set the same one.

Best,