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 getting this error in the error_log? Donny > -----Original Message----- > From: Michael Grubb [mailto:[EMAIL PROTECTED] > Sent: Monday, November 15, 2004 2:49 PM > To: [EMAIL PROTECTED] > Subject: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and > (utf8_general_ci,COERCIBLE) and Replication > > Hello all, > I'm having a very peculiar and nerve racking experience with MySQL 4.1.7 > running on Fedora Core 2. > On the master the query executes just fine, however on the slave I get: > Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and > (utf8_general_ci,COERCIBLE) for operation '='' on query. Default > database: 'BRITEERNO'. Query: 'Update contacts > set firstname = 'XXXX',lastname = 'XXXX',email = > 'XXXX' ,company = 'XXXX',address1 = 'XXXX',address2 = '' > ,address3 = '',city = 'XXXX',state = > 'XX' ,zip = 'XXXX', country = 'XX',phone = 'XXXX' > ,fax = '',user = 'XXXX',pass = > 'XXXX',changed_on = now() ,status = 'X' > where RNK_id = 'XXXX'' > > > I'm completely and uterly stumped by this, I have no idea of where to go > from here. > Any help will be greatly appreciated. > > Thank, > > Michael Grubb > 000domains.com > > Below is output from my master and slave "show variables" command. > > Show variables on the master: > > character_set_client latin1 > > character_set_connection latin1 > character_set_database latin1 > character_set_results latin1 > > character_set_server latin1 > character_set_system utf8 > character_sets_dir /usr/share/mysql/charsets/ > collation_connection > latin1_swedish_ci > collation_database > latin1_swedish_ci > collation_server latin1_swedish_ci > > Show variables on the slave: > character_set_client latin1 > character_set_connection latin1 > character_set_database latin1 > character_set_results latin1 > character_set_server > latin1 > character_set_system utf8 > character_sets_dir /usr/share/mysql/charsets/ > collation_connection latin1_swedish_ci > collation_database > latin1_swedish_ci > collation_server > latin1_swedish_ci -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
