Thread: problems with tsearch
Please, can anybody help me? I'm trying to use tsearch on a specific database, but the texts I'm indexing are in portuguese. So, everytime I search for a word with a graphical sign (á, é, ô, etc.) I got an empty resultset. I've already tested it on an ascii encoded database and on an latin1 encoded database. Thanks in advance, -- Diogo de Oliveira Biazus diogo@ikono.com.br Ikono Sistemas e Automação http://www.ikono.com.br
You should use portuguese stemmer. Current tsearch isn't very flexible, but it's possible. Try to look on tsearch2 on http://www.sai.msu.su/~megera/postgres/gist/ Diogo de Oliveira Biazus wrote: > > Please, can anybody help me? > I'm trying to use tsearch on a specific database, > but the texts I'm indexing are in portuguese. > So, everytime I search for a word with a graphical sign (á, é, ô, etc.) > I got an empty resultset. > I've already tested it on an ascii encoded database and on an latin1 > encoded database. > > Thanks in advance, > -- Teodor Sigaev teodor@stack.net