Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='

Posted on 2006-04-24
Medium Priority
Last Modified: 2006-11-18
I have a problem: when I try to execute  a select in mysql administrator, say this error:
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='

in a foro I read somebody fixed this problem changing the fields of a table to utf8_spanish2_ci, but I don't know how to do this in mysql administrator 1.1.1. Can you help me? or: Can you suggest me another solution? I need help urgentlly!  
Question by:mnateras
1 Comment
LVL 17

Accepted Solution

akshah123 earned 2000 total points
ID: 16529142
Follow following steps in mysql administrator ...

* Open administrator and login to the appropriate server

* On the tabs on the left hand side, select catalog.

* Select appropriate database from the menu under the tabs.

* At this point, you should see tables under the database on the main window. The tab on top should say "Schema tables"

* Select appropriate table from the list.

* Click "Edit Table" Button at the bottom.

* ON the popup window go to tab labelled 'Column and indeces"

* Select appropriate columns

* On the window right below column lists, select tab "Column Details"

* Select appropirate column charset.

Hope this helps


Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
In this blog, we’ll look at how improvements to Percona XtraDB Cluster improved IST performance.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses
Course of the Month14 days, 18 hours left to enroll

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question