select users.id_user, login, collections.id_collection, nom_collection from collections inner join users using(id_user) where collections.id_collection='3552' and collections.id_user='1478' and (collections.type_album='public' OR (collections.type_album='privé' AND collections.cle_visiteur=''))
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '='