RE: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) and Replication

2004-11-15 Thread Donny Simonton
Michael, Normally I would let a fellow domain registrar fend for themselves, but I'm feeling nice today. :) Do a show create table contacts and see what the charset is set too. I bet the character set on the slave is different. Are you running this from the command line? Or are you

Re: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) and Replication

2004-11-15 Thread Michael Grubb
Donny, I certainly appreciate your help. "show create table contacts" shows the same output on both the master and the slave ('latin1'). This is being run by the slave's SQL thread, and the Error is shown in the "Last error" line of "show slave status" and the error log. Thanks again,

RE: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) and Replication

2004-11-15 Thread Donny Simonton
Got me stumped on this one, I've been using 4.1 for over a year now and I haven't run into this problem except somebody was using phpmyadmin or something. Maybe somebody else can help with this one, sorry. Donny _ From: Michael Grubb [mailto:[EMAIL PROTECTED] Sent: Monday,