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: PGP signature
Description: OpenPGP digital signature
