Comment 30 for bug 553133

Revision history for this message
Albert Cervera i Areny - http://www.NaN-tic.com (albert-nan) wrote : Re: [Bug 553133] Re: Search with accents

A Dilluns, 9 d'agost de 2010, Borja López Soilán (Pexego) va escriure:
> Albert, we are using Postgres 8.4 and it actually works that way for us!
> You can search for a plural or singular and it will match both (though
> with different scores)!

I think it's spanish version of snowball (the library that looks for the root
of a word) that it's "simulating" the unaccent functionality here. For
example, if you try to write the catalan word "diferència", you won't find it
simply because spanish version of snowball cannot understand the 'è'
character.

Something more robust such as the upcomming 'unaccent' module which won't be
available until postgres 9.0, should be used:

http://www.postgresql.org/docs/9.0/static/unaccent.html

--
Albert Cervera i Areny
http://www.NaN-tic.com
OpenERP Partners
Mòbil: +34 669 40 40 18

http://twitter.com/albertnan
http://albert-nan.blogspot.com