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:mgrubb@stripped]
> Sent: Monday, November 15, 2004 2:49 PM
> To: mysql@stripped
> 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
