• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 775
  • Last Modified:

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

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!  
1 Solution
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

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now