Issue 13959
Special characters are not interpreted in publisher search
13959
Reporter: fmendez
Assignee: fmendez
Type: Bug
Summary: Special characters are not interpreted in publisher search
Priority: Major
Resolution: Fixed
Status: Resolved
Created: 2013-09-18 14:50:55.883
Updated: 2015-03-19 18:57:05.704
Resolved: 2015-03-19 18:57:05.678
Description: The search http://portaldev.gbif.org/publisher/search?q=comisi%C3%B3n correctly returns CONABIO
but http://portaldev.gbif.org/publisher/search?q=comision returns 0 results]]>
Author: fmendez@gbif.org
Created: 2013-10-04 13:50:31.673
Updated: 2013-10-04 13:50:31.673
A possible solution is to install the 'unaccent' extension and then use the unaccent function in several places:
1. CREATE EXTENSION unaccent;
2. In the MyBatis mappers: c.fulltext_search @@ plainto_tsquery('english',unaccent(#{query}))
3. Modify all the full text search triggers in this way:
NEW.fulltext_search :=
TO_TSVECTOR('pg_catalog.english', COALESCE(unaccent(NEW.title),'')) ||..
4. 'Reindex' all the data, this step requires execute all the fulltextsearch triggers in some way( maybe we can do it for the next migration).