PDA

View Full Version : SOA: Illegal mix of collations


holykim
25th October 2010, 09:41
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

holykim
26th October 2010, 07:10
No one can help me?

Regards,

Harry

till
26th October 2010, 10:08
Check your mysql configuration files, especially the my.cnf and ensure that you use utf-8 and not euckr_korean_ci as collation type.