MySQL Bugs: #9094: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general

Bug #9094	Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COE
Submitted:	10 Mar 2005 13:30	Modified:	15 May 2005 5:14
Reporter:	joe byers	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Query Browser	Severity:	S2 (Serious)
Version:	1.1.6	OS:	Windows (Winxp and linux)
Assigned to:		CPU Architecture:	Any

Description:
Executing the following statement
select * from pjmwork.nodecounts where zone_source not in ('AEP');
I get the synopsis error.

This error occurs on both winxp and linux versions of query browser when querying a Mysql db on a linux system.  It does not occur when querying a Mysql db on a winxp system. 

The not in syntax fails.  If I do a zone_source<>'AEP the query returns the correct results. 

I have tried everything relating to collations and related mysql db options to get this to work.  Other posts in the forums have referenced the internal setting of querybrowser.

I also have sqlyog software and the query above works correctly.  As does toadmysql.  Because these other two softwares correctly execute the query with zone_source not in ('AEP'), I am certain this is a bug in querybrowser.

How to repeat:
Execute a query with a not in componet on a linux system or connect to the mys ql db on a linux system from a winxp and execute the query.

Suggested fix:
See reference to sqlyog and toadmysql above.

Hi

I was unable to repeat this bug report.  I tried executing the following queries and they all worked as expected:

use mysql;
SELECT * FROM user where Host not in ('localhost');
SELECT * FROM user where Host is not null;

Can you please give me an example query using the tables in the mysql database that cause this behaviour ?

Thanks

Hi!

I just changed the status of this bug report to 'Need Feedback'

Could you please send me a copy of your tables so that I can reproduce this bug ?

Thanks a lot.

zipped file of table and table definition

Attachment: nodecounts.zip (application/x-zip-compressed, text), 3.07 KiB.

I added the files and for closing the bug, no problem.  Happens sometimes.

thanx again

Jorge,
sorry if i add a comment here, but i think it's the same bug as 9006 - just to make sure that you and Hartmut Holzgraefe are not doubling the work.... 
Bye
Emanuele

Emanuele and Jorge

This bug is very similar to 9006 with a couple of specific added.

This bug occurs when querying a mysqldb on a linux server (redhat 9) from both the linux and a winxp systems versions of query browser.  The linux system is querying the server localhost or the hostname for the linux server, both fail.

The error DOES NOT occur when querying a mysqldb on winxp localhost server using the winxp version of querybrowser.

It should be noted that the same version of querybrowser is used on the winxp box for both test queries.

thanx again and good luck
joe

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

I would like to update the severity from non-critical to serious.

This is still a problem.  Does anyone know the status of this problem.  Because the collation does not work in mysqlquerybrowser, I have to use sqlyog on my xp box, which is not a bad thing for the xp box.  But, on linux, I am out of luck.