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 = '',lastname = '',email =
'' ,company = '',address1 = '',address2 = ''
,address3 = '',city = '',state =
'XX' ,zip = '', country = 'XX',phone = ''
,fax = '',user = '',pass =
'',changed_on = now() ,status = 'X'
where RNK_id = '''
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
