Illegal mix of collations

cocolala

Last_Error: Error 'Illegal mix of collations (binary,IMPLICIT) and (binary,NONE) for operation '>='' on query. Default database: 'c2cboss'. Query: 'insert into BossLawSuitContent2
(RequestID,SpeakUin,
SpeakContent,
SpeakTime,AddPath,SpeakNick,
SpeakTitle,SpeakType)
select RequestID,0,
@lawsuit_sys_speak,
sysdate(),'','system',
'',1
from BossLawSuit2
where RequestTime >= @lawsuit_begin_time
and RequestTime  show slave status \G
*************************** 1. row ***************************
             Slave_IO_State: Waiting for master to send event
                Master_Host: 172.16.130.68
                Master_User: repl
                Master_Port: 3306
              Connect_Retry: 60
            Master_Log_File: boos_db_68-bin.000454
        Read_Master_Log_Pos: 77279522
             Relay_Log_File: db_boss_b-relay-bin.000044
              Relay_Log_Pos: 261250554
      Relay_Mas
ter_Log_File: boos_db_68-bin.000454
           Slave_IO_Running: Yes
          Slave_SQL_Running: No
            Replicate_Do_DB: c2cboss,c2cbossbak,seller_point
        Replicate_Ignore_DB: mysql
         Replicate_Do_Table:
     Replicate_Ignore_Table:
    Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
                 Last_Errno: 1267
                 Last_Error: Error 'Illegal mix of collations (binary,IMPLICIT) and (binary,NONE) for operation '>='' on que
ry. Default database: 'c2cboss'. Query: 'insert into BossLawSuitContent2
(RequestID,SpeakUin,
SpeakContent,
SpeakTime,AddPath,SpeakNick,
SpeakTitle,SpeakType)
select RequestID,0,
@lawsuit_sys_speak,
sysdate(),'','system',
'',1
from BossLawSuit2
where RequestTime >= @lawsuit_begin_time
and RequestTime
            Relay_Log_Space: 268645142
            Until_Condition: None
             Until_Log_File:
              Until_Log_Pos: 0
         Master_SSL_Allowed: No
         Master_SSL_CA_File:
         Master_SSL_CA_Path:
            Master_SSL_Cert:
          Master_SSL_Cipher:
             Master_SSL_Key:
      Seconds_Behind_Master: NULL
1 row in set (0.00 sec)

本文来自ChinaUnix博客，如果查看原文请点：http://blog.chinaunix.net/u2/67276/showart_677802.html