From af5872b7d432f78befcb7e9f87187a5b82b588bf Mon Sep 17 00:00:00 2001 From: Jean-Philippe Lang Date: Sun, 8 Feb 2015 15:13:57 +0000 Subject: Support for accent insensitive search with PostgreSQL (#18801). If the unaccent extension is installed, the search engine will use it in order to do accent insensitive search. git-svn-id: http://svn.redmine.org/redmine/trunk@13989 e93f8b46-1217-0410-a6f0-8f06a7374b81 --- lib/plugins/acts_as_searchable/lib/acts_as_searchable.rb | 9 ++++++--- 1 file changed, 6 insertions(+), 3 deletions(-) (limited to 'lib/plugins/acts_as_searchable') 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 -- cgit v1.2.3