search on accents over all possible matches

From: Jaume Teixi <teixi(at)6tems(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: search on accents over all possible matches
Date: 2001-03-27 16:24:14
Message-ID: 20010327182414.4fa5c583.teixi@6tems.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jaume Teixi 2001-03-27 16:35:19 non postgres user need to perform COPY
Previous Message antken 2001-03-27 16:10:15 Starting postgresql on boot