mysql 字元集錯誤 Illegal mix of collations

標籤：

  SELECT * FROM     mobile_card.mcc_o2o_repayment_request orr         INNER JOIN     bi_o2o_sfq.CARD C ON C.CARDID = orr.cardno LIMIT 0, 50

Error Code: 1267. Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation ‘=‘ 0.038 sec

這個是Mysql字元集錯誤

SELECT *

FROM

    mobile_card.mcc_o2o_repayment_request orr

        INNER JOIN

    bi_o2o_sfq.CARD C ON C.CARDID = orr.cardno COLLATE utf8_unicode_ci

給錯誤的字元集合，給強制轉化一下  加   COLLATE utf8_unicode_ci

mysql 字元集錯誤 Illegal mix of collations