SOA: Illegal mix of collations
 

Hello

Recentely I have got the following errors in message log file. Can anyone to help me to resolve this issue?

Oct 25 20:14:06 hostname mydns[4100]: b._dns-sd._udp. Õ)m.: error loading SOA: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (euckr_korean_ci,COERCIBLE) for operation '=' (errno=0)
Oct 25 20:14:06 hostname mydns[4100]: db._dns-sd._udp. Õ)m.: error loading SOA: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (euckr_korean_ci,COERCIBLE) for operation '=' (errno=0)
Oct 25 20:14:06 hostname mydns[4100]: r._dns-sd._udp. Õ)m.: error loading SOA: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (euckr_korean_ci,COERCIBLE) for operation '=' (errno=0)
Oct 25 20:14:06 hostname mydns[4100]: dr._dns-sd._udp. Õ)m.: error loading SOA: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (euckr_korean_ci,COERCIBLE) for operation '=' (errno=0)
Oct 25 20:14:06 hostname mydns[4100]: lb._dns-sd._udp. Õ)m.: error loading SOA: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (euckr_korean_ci,COERCIBLE) for operation '=' (errno=0)


Thanks in advance.

Harry

No one can help me?

Regards,

Harry

Check your mysql configuration files, especially the my.cnf and ensure that you use utf-8 and not euckr_korean_ci as collation type.