asked on

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

I get the following warning "Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' ".

CREATE TABLE `evenemang` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`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`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

boka-1-admin.php

How come?

gr8gonzo

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.

ASKER CERTIFIED SOLUTION

gr8gonzo

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Lennart Ericson

ASKER

Thanks