I have a problem: when I try to execute a select in mysql administrator, say this error:
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='
in a foro I read somebody fixed this problem changing the fields of a table to utf8_spanish2_ci, but I don't know how to do this in mysql administrator 1.1.1. Can you help me? or: Can you suggest me another solution? I need help urgentlly!