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

Posted on 2006-04-24
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

    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 Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    More Fun with XML and MySQL – Parsing Delimited String with a Single SQL Statement Are you ready for another of my SQL tidbits?  Hopefully so, as in this adventure, I will be covering a topic that comes up a lot which is parsing a comma (or other…
    All XML, All the Time; More Fun MySQL Tidbits – Dynamically Generate XML via Stored Procedure in MySQL Extensible Markup Language (XML) and database systems, a marriage we are seeing more and more of.  So the topics of parsing and manipulating XM…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    745 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

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now