I admit first that charsets and collation are something new to me since version 5 - if you have any good links to read that explain how that relates to this problem, please let me know in your reply and I'll review.
I have a mysql server that is on a WINDOWS machine (it's another client's, all my sites are on Linux). When I run this query:
SQL-query:
DELETE FROM mlsre_importfiles_errors WHERE content LIKE '%search for properties%'
I get this result:
MySQL said: Documentation
#1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'
here is the show create table:
CREATE TABLE mlsre_importfiles_errors (
ID int(11) unsigned NOT NULL auto_increment,
Importfiles_ID int(11) unsigned NOT NULL default '0',
Content text NOT NULL,
EditDate timestamp NOT NULL default CURRENT_TIMESTAMP,
PRIMARY KEY (ID),
KEY Importfiles_ID (Importfiles_ID)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
however, in phpmyadmin, I note that that field Content's collation type is:
latin1_swedish_ci
What's the problem here coach? Thanks for your assistance in advance.
Samuel
