I have upgraded a website from drupal 4.7.4 to drupal 5.1 (I have also moved
website from one server to another), now when I try to login I'm getting
following error.
user warning: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and
(utf8_general_ci,COERCIBLE) for operation '=' query
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
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
wedish_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,
, November 15, 2004 4:23 PM
To: Donny Simonton
Cc: [EMAIL PROTECTED]
Subject: Re: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and
(utf8_general_ci,COERCIBLE) and Replication
Donny,
I certainly appreciate your help.
show create table contacts shows the same output on both the master
make a select like
SUBSTRING_INDEX( domain, '.', -2 ) from url_cat, the following
error-message appears: Error #1267 - Illegal mix of collations
(latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE). I found out,
that if I use the following statement select SUBSTRING_INDEX( domain,
_latin1
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 18, 2004 9:35 AM
To: [EMAIL PROTECTED]
Subject: Problem with Mysql 4.1.3: Error #1267 - Illegal mix of collations
(latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE)
Hi All
I am very confused about MySQL 4.1.3. I have problems