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

Posted on 2014-01-22
Last Modified: 2014-01-22
I get the following warning "Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' ".

CREATE TABLE `evenemang` (
  `resanr` int(11) DEFAULT NULL,
  `datum` date NOT NULL DEFAULT '0000-00-00',
  `titel` varchar(50) DEFAULT NULL,
  `plats` varchar(50) DEFAULT NULL,
  `antal_biljetter` int(11) DEFAULT '0',
  `resa_pris` int(11) DEFAULT '0',
  `antal_frukost` int(11) DEFAULT '0',
  `frukost_pris` int(11) DEFAULT '0',
  `antal_lunch` int(11) DEFAULT '0',
  `lunch_pris` int(11) DEFAULT '0',
  `antal_middag` int(11) DEFAULT '0',
  `middag_pris` int(11) DEFAULT '0',
  `antal_vickning` int(11) DEFAULT '0',
  `vickning_pris` int(11) DEFAULT '0',
  `beskrivning` blob,
  `date` date DEFAULT NULL,
  `time` time DEFAULT NULL,
  `ip` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)


How come?
Question by:lericson
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
LVL 35

Expert Comment

ID: 39799937
Your database probably has a utf8 default charset, and you're trying to define a latin1 character set in your table. Try changing the "DEFAULT CHARSET" part of your statement to use the utf8 character set for the database.
LVL 35

Accepted Solution

gr8gonzo earned 500 total points
ID: 39799947
If your table is already created and you're getting that error during inserts / updates, then convert your table to utf8:

ALTER TABLE `evenemang` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

You may need to do this for other tables, too. I'd always recommend using utf-8 over latin1 nowadays.

Author Closing Comment

ID: 39801795

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying 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

Suggested Solutions

Title # Comments Views Activity
Very Large data in MYSQL 7 105
MYSQL responding very slow 3 63
migrating to phpbb forum from vBulletin 4.2 3 89
mysql qry 1 37
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
This article shows the steps required to install WordPress on Azure. Web Apps, Mobile Apps, API Apps, or Functions, in Azure all these run in an App Service plan. WordPress is no exception and requires an App Service Plan and Database to install
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

738 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