I'm actually developping an application using delphi as a programming laguage and mariaDB as a database server, i generate a query with the application witch creates variables in the connection session and affecte to them values, my problem accours when try to compare the value of a variable and a database field i have the message: illegal mix of collations (utf8_general_ci implicit) and (utf8_unicode_ci implicit) but whene i try to execute the same query in a database administration tool (heidiSQL) it runs normally.
Example of query : set @code_employe = '000';
set @nbr_enf_en_charge := (select valeur from employe_info_libre where code_info_libre = 'Question1' and code_employe = @code_employe) ;
select @nbr_enf_en_charge as nbr_enf_en_charge ;
And i think that is the collation used for the encoding of the variables values and i want to set it to utf8_unicode_ci. Thank you