kwstephenchan Posted September 16, 2007 Share Posted September 16, 2007 Hi Folks, I got this error message "illogical mix of collation (gb2312_chinese_ci, implicit) and (latin_swedish_ci, coercible) for operator "=". It is a new table and there is no data in this table yet. I have read answers regarding collation and suggestion was to alter table. Since this is a new table and no data in it, will alter table be applicable?? If it still is, what should I do in altering the table?? Could it be the configuration that I should change (from default set up)?? Could someone help?? Cheers Kwstephenchan Quote Link to comment Share on other sites More sharing options...
fenway Posted September 18, 2007 Share Posted September 18, 2007 What are the collations for the tables/columns? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.