Feature #18801

Support for accent insensitive search with PostgreSQL

Added by Jean-Philippe Lang almost 4 years ago. Updated over 3 years ago.

Status:ClosedStart date:
Priority:NormalDue date:
Assignee:Jean-Philippe Lang% Done:

0%

Category:Search engine
Target version:3.0.0
Resolution:Fixed

Description

Redmine should use the unaccent() function to do accent insensitive search if the unaccent extension is installed.

This extension is available in PostgreSQL 9 and can be installed with:

CREATE EXTENSION IF NOT EXISTS unaccent;

Associated revisions

Revision 13989
Added by Jean-Philippe Lang over 3 years ago

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.

History

#1 Updated by Jean-Philippe Lang almost 4 years ago

  • Category set to Search engine
  • Assignee set to Jean-Philippe Lang

#2 Updated by Jean-Philippe Lang over 3 years ago

  • Status changed from New to Closed
  • Resolution set to Fixed

Feature added in r13989. If the extension is installed, Redmine will automatically uses unaccent() when performing a search.

Also available in: Atom PDF