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

[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, Michael Donny Simonton wrote: 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

signature.asc
Description: OpenPGP digital signature