I’m getting this strange error while processing a large number of data…
Error Number: 1267 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '=' SELECT COUNT(*) as num from keywords WHERE campaignId='12' AND LCASE(keyword)='hello again æ˜” ã‹ã‚‰ ã‚ã‚‹ å ´æ‰€'Solusi :
SET collation_connection = 'utf8_general_ci'
then for your databases
ALTER DATABASE db CHARACTER SET utf8 COLLATE utf8_general_ci
ALTER TABLE table CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci
MySQL sneaks swedish in there sometimes for no sensible reason.