| Bug #9138 | #9094: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general | ||
|---|---|---|---|
| Submitted: | 11 Mar 2005 23:44 | Modified: | 11 Mar 2005 23:54 |
| Reporter: | joe byers | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Query Browser | Severity: | S3 (Non-critical) |
| Version: | 1.1.6 | OS: | Windows (winxp and linux) |
| Assigned to: | CPU Architecture: | Any | |
[11 Mar 2005 23:54]
Jorge del Conde
Sorry for closing the bug. I have re-opened 9094.
[12 Mar 2005 5:04]
joe byers
zipped file of table and table definition
Attachment: nodecounts.zip (application/x-zip-compressed, text), 3.07 KiB.
Description: I am resubmitting this bug because you closed it before I could answer your questions. I tried your query use mysql; SELECT * FROM user where Host not in ('localhost'); and it worked on my machines as well. The mysql system DB seems to have settings that do not trigger this error. The query that I have in the original post is a working query. Do you want me to send my tables to you? Are there any systems setting, db settings, or table settings that would I could provide that would help you. Also, if I open the command line client my query works fine. Only in querybrowser does it bomb. thankyou for your help. greatly appreciated joe How to repeat: see original bug