unicode error at version 3.4.2

Added by Raindy Long 3 months ago

Next is the log information, how to fix? Thanks .

Started GET "/users?utf8=%E2%9C%93&status=1&group_id=&name=%E7%8E%8B%E7%9D%BF" for 172.16.1.1 at 2017-08-03 17:57:20 +0800
Processing by UsersController#index as HTML
  Parameters: {"utf8"=>"✓", "status"=>"1", "group_id"=>"", "name"=>"王睿"}
  Current user: xxxx (id=69)
Completed 500 Internal Server Error in 21ms (ActiveRecord: 11.8ms)

ActiveRecord::StatementInvalid (Mysql2::Error: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like': SELECT COUNT(*) FROM `users` WHERE `users`.`type` IN ('User', 'AnonymousUser') AND (users.status <> 0) AND `users`.`status` = 1 AND (LOWER(users.login) LIKE LOWER('%王睿%') OR LOWER(users.firstname) LIKE LOWER('%王睿%') OR LOWER(users.lastname) LIKE LOWER('%王睿%') OR users.id IN (SELECT user_id FROM email_addresses WHERE LOWER(address) LIKE LOWER('%王睿%')))):
  app/controllers/users_controller.rb:50:in `index'
  lib/redmine/sudo_mode.rb:63:in `sudo_mode'