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
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