On Wed, 18 Mar 2009, cifroes wrote:


I have a DB in utf-8 and postgres 8.3.x.

How can I do an accent insensitive search (like ...) ?

Take a look on text search capability and http://www.sai.msu.su/~megera/wiki/unaccent
We have patches for CVS HEAD, but unfortunately they will likely
go to the 8.5 release

Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: o...@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83

Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:

Reply via email to