summaryrefslogtreecommitdiffstats
path: root/lib/plugins/acts_as_searchable
diff options
context:
space:
mode:
Diffstat (limited to 'lib/plugins/acts_as_searchable')
-rw-r--r--lib/plugins/acts_as_searchable/lib/acts_as_searchable.rb9
1 files changed, 6 insertions, 3 deletions
diff --git a/lib/plugins/acts_as_searchable/lib/acts_as_searchable.rb b/lib/plugins/acts_as_searchable/lib/acts_as_searchable.rb
index e490c8fa7..96d1c2588 100644
--- a/lib/plugins/acts_as_searchable/lib/acts_as_searchable.rb
+++ b/lib/plugins/acts_as_searchable/lib/acts_as_searchable.rb
@@ -159,9 +159,12 @@ module Redmine
private :search_tokens_condition
def search_token_match_statement(column, value='?')
- case connection.adapter_name
- when /postgresql/i
- "#{column} ILIKE #{value}"
+ if Redmine::Database.postgresql?
+ if Redmine::Database.postgresql_unaccent?
+ "unaccent(#{column}) ILIKE unaccent(#{value})"
+ else
+ "#{column} ILIKE #{value}"
+ end
else
"#{column} LIKE #{value}"
end