Defect #25867

Assignable users should respect database collation

Added by Pavel Rosický over 5 years ago. Updated about 4 years ago.

Status:NewStart date:
Priority:NormalDue date:
Assignee:-% Done:


Target version:Candidate for next major release
Resolution: Affected version:


mysql collation: utf8_general_ci
['a','u','č'] should be sorted as ['a','č','u'] but because of ruby sort it's reordered back as ['a','u','č']

  def assignable_users
    users = project.assignable_users(tracker).to_a
    users << author if author &&
    if assigned_to_id_was.present? && assignee = Principal.find_by_id(assigned_to_id_was)
      users << assignee


I can provide a patch, are you interested or is it desired behaviour?

Environment (not important, all redmine versions and databases are affected):
  Redmine version                3.3.3.devel.16557
  Ruby version                   2.1.5-p273 (2014-11-13) [x64-mingw32]
  Rails version                  4.2.8
  Environment                    production
  Database adapter               Mysql2
  Subversion                     1.9.5
  Git                            2.11.0
Redmine plugins:
  no plugin installed

issue_test.rb.patch Magnifier (883 Bytes) Pavel Rosický, 2017-05-18 21:57

issue.rb.patch Magnifier (1.16 KB) Pavel Rosický, 2017-05-18 21:57


#1 Updated by Pavel Rosický over 5 years ago

#2 Updated by Pavel Rosický over 4 years ago

It's been a year and the problem is still reproducible.

#3 Updated by Go MAEDA about 4 years ago

  • Target version set to Candidate for next major release

Also available in: Atom PDF