diff options
| author | Jean-Philippe Lang <jp_lang@yahoo.fr> | 2015-02-08 15:13:57 +0000 |
|---|---|---|
| committer | Jean-Philippe Lang <jp_lang@yahoo.fr> | 2015-02-08 15:13:57 +0000 |
| commit | af5872b7d432f78befcb7e9f87187a5b82b588bf (patch) | |
| tree | cb8420064142f4c3a3d95b2f9ad5ca21232cbf3b /lib/plugins | |
| parent | aeb6dbc306163548a78d320d291b45b17b2ecf7f (diff) | |
| download | redmine-af5872b7d432f78befcb7e9f87187a5b82b588bf.tar.gz redmine-af5872b7d432f78befcb7e9f87187a5b82b588bf.zip | |
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
Diffstat (limited to 'lib/plugins')
| -rw-r--r-- | lib/plugins/acts_as_searchable/lib/acts_as_searchable.rb | 9 |
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 |