Hi,



I am new here. Please help!!!



I was about to reassign the defect to another user account,
anotheruser@email.com for example. After select "Reassign buy to
anotheruser@email.com", then click on "Commit" button, I got below
error,


Software error:

DBD::mysql::db do failed: Illegal mix of collations
(utf8_general_ci,COERCIBLE) and (latin1_swedish_ci,IMPLICIT) for
operation 'case' [for Statement "UPDATE bugs SET
rep_platform = ?,
priority = ?,
bug_severity = ?,
bug_file_loc = ?,
short_desc = ?,
version = ?,
op_sys = ?,
target_milestone = ?,
product_id = ?,
component_id = ?,
bug_status = CASE WHEN bug_status IN('NEW', 'REOPENED', 'ASSIGNED',
'UNCONFIRMED') THEN (CASE WHEN everconfirmed = 1 THEN 'NEW' ELSE
'UNCONFIRMED' END) ELSE bug_status END,
assigned_to = ?,
estimated_time = ?,
remaining_time = ?,
deadline = ? WHERE bug_id = ?"] at C:/bugzilla3/process_bug.cgi line
1689

I tried to update bugs manually without problem. Could you please help
why I got this error, and how to solve the problem?
Thank you very much!!!
sheng