Diacritics and search

Contribute Feature
13

I think this is a feature request if anything, but looking at the doco by @MakaryGo I think running something like:

./launcher enter app
sudo postgres psql discourse
discourse=# CREATE EXTENSION unaccent;
discourse=# CREATE TEXT SEARCH CONFIGURATION en ( COPY = english);
discourse=# ALTER TEXT SEARCH CONFIGURATION en
        ALTER MAPPING FOR hword, hword_part, word
        WITH unaccent, english_stem;
discourse=# select to_tsvector('en','Hôtels de la Mer');
           to_tsvector           
---------------------------------
 'de':2 'hotel':1 'la':3 'mer':4
(1 row)

I do wonder @codinghorror if we should unaccent out-of-the-box or not.

2 « J'aime »