I use PostgreSQL 10 and I run CREATE EXTENSION unaccent; succesfully. I have a plgsql function that contains the following whereText := 'lower(unaccent(place.name)) LIKE lower(unaccent($1))'; late...

How can I modify a where/like condition on a search query in Rails: find(:all, :conditions => ["lower(name) LIKE ?", "%#{search.downcase}%"]) so that the results are matched irrespective of ac...

I want to retrieve a way with a given name from an OpenStreetMap database imported into PostgreSQL 9.3.5, the OS is Win7 64-bit. In order to be a bit failure tolerant, I use the unaccent extension ...

I am trying to configure PostgreSQL to use fulltext search in my rails app as mentioned in this Railscast. I am using a fresh Ubuntu 12.04 server running PostgreSQL 9.1.5 installed using apt-get w...

I am trying to install the contrib/unaccent package for Postgresql 8.4 on my Ubuntu box. But I got the error message when I typed make: /usr/lib/postgresql/8.4/lib/pgxs/src/makefiles/pgxs.mk: No...