search on accents over all possible matches - Mailing list pgsql-admin

From Jaume Teixi
Subject search on accents over all possible matches
Date
Msg-id 20010327182414.4fa5c583.teixi@6tems.com
Whole thread Raw
Responses Re: search on accents over all possible matches  (David Lizano <david.lizano@izanet.com>)
Re: search on accents over all possible matches  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-admin
Hello,

I'm developing a search tool with php against a posgresql database.
As the database is in catalan an in spanish is obvious that a simple
search like:
(SELECT * FROM painters WHERE artist_name ~* 'Dali');

should perform over Dd Aa Ll Ii (and will not found Dalí).
but on an accent based language also should perform over ÍíÌìÏï

question is:

this c function from Patrice Hédé is the most appropiate tool for
searching on an accent based language ?
http://www.postgresql.org/mhonarc/pgsql-sql/1998-06/msg00119.html

or should I use an implemented function inside postgres right now ?

bests from barcelona,
jaume teixi.

pgsql-admin by date:

Previous
From: Marcin Kowalski
Date:
Subject: pg_dump potential bug
Next
From: Jaume Teixi
Date:
Subject: non postgres user need to perform COPY