Gossamer Forum
Home : General : Databases and SQL :

#1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT)

Quote Reply
#1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT)
Hi,

When using the following query:

select * from PalletDetails where
ProductCode='QM004LA3' and Deleted=0

I got this error

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

Is this caused by my query or the table structure itself? Although with some other ProductCode, it is fine.

Any suggestions?

Thanks,

Cheers,

Dat

Programming and creating plugins and templates
Blog
Quote Reply
Re: [tandat] #1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) In reply to
It seemed phpmyadmin causes that error.

Thanks,

Cheers,

Dat

Programming and creating plugins and templates
Blog
Quote Reply
Re: [tandat] #1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) In reply to
I'm not sure it is specifically to do with PhpMyAdmin but I found lots of details here:

http://search.yahoo.com/...mp;cop=&ei=UTF-8
Quote Reply
Re: [Hargreaves] #1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) In reply to
Thanks for your information. That's very helpful!

Cheers,

Cheers,

Dat

Programming and creating plugins and templates
Blog