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

Scripts installation and plugin creation
Plugins

It seemed phpmyadmin causes that error.

Thanks,

Cheers,

Dat

Scripts installation and plugin creation
Plugins

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

Thanks for your information. That's very helpful!

Cheers,

Cheers,

Dat

Scripts installation and plugin creation
Plugins