Illegal mix of collations

时间：2008-05-06 来源：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 < @lawsuit_end_

time
and RequestType = 1
and RequestState not in(4,5,6)'

mysql> 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 < @lawsuit_end_time
and RequestType = 1
and RequestState not in(4,5,6)'
               Skip_Counter: 0
        Exec_Master_Log_Pos: 69884934
            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)