Refs #7004 Lower params[:sort] to avoid sort bugs7004-companies-sort-name

1 files changed, 2 insertions, 2 deletions

diff --git a/app/controllers/companies_controller.rb b/app/controllers/companies_controller.rb
index 2c32ed3a5..c359dfd6d 100644
--- a/app/controllers/companies_controller.rb
+++ b/app/controllers/companies_controller.rb
@@ -44,9 +44,9 @@ class CompaniesController < ChouetteController
     ids = @q.result(:distinct => true).pluck(:id)
     scope = scope.where(id: ids)
     if sort_column && sort_direction
-      @companies ||= scope.order(sort_column + ' ' + sort_direction).paginate(:page => params[:page])
+      @companies ||= scope.order("lower(#{sort_column})" + ' ' + sort_direction).paginate(:page => params[:page])
     else
-      @companies ||= scope.order(:name).paginate(:page => params[:page])
+      @companies ||= scope.order('lower(name)').paginate(:page => params[:page])
     end
   end