can you suggest how i can fix this problem with a php mysql script that i am using the errror is:

Illegal mix of collations (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation 'ifnull'