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

2007-05-02 Thread Sharique uddin Ahmed Farooqui
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

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

2004-11-15 Thread Michael Grubb
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

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

2004-11-15 Thread Donny Simonton
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

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

2004-11-15 Thread Michael Grubb
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,

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

2004-11-15 Thread Donny Simonton
, 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

Problem with Mysql 4.1.3: Error #1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE)

2004-08-18 Thread Martin Rytz
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

RE: Problem with Mysql 4.1.3: Error #1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE)

2004-08-18 Thread Donny Simonton
[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