I have imported mysql data from my local machine to webserver through phpmyadmin and when I run my script I am getting this error
Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '='
why is this?? and how can I solve this??
ircmaxell :
The problem is because of the collation of your connection vs the collation of the column being compared. You have three real options. Either cast your comparison to the appropriate collation, change your column's collation or change your connection's collation.\n\nTo cast:\n\nWHERE fooColumn = CAST('test' AS CHAR CHARACTER SET utf8) COLLATE utf8_general_ci\n\n\nTo Change column collation:\n\nALTER TABLE fooTable \n MODIFY follColumn VARCHAR(255) CHARACTER SET utf8 COLLATE utf8_general_ci;\n\n\nTo change the connection collation:\n\nSET NAMES utf8 COLLATE utf8_general_ci\n\n\nEtc. If you want more explicit information, show your query and your table definitions.",
2011-02-03T17:57:26