Seaching with and without diacritical marks

From: "Ullrich Ralf" <Ullrich(at)iai(dot)spk-berlin(dot)de>
To: "Pgsql-Novice (E-Mail)" <pgsql-novice(at)postgresql(dot)org>
Subject: Seaching with and without diacritical marks
Date: 2004-07-13 12:20:48
Message-ID: 594F2B88520FB045BA370245CB19BBF06866EB@ExchangePK1.pk.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello,

I have a multilingual portal running on PostgreSQL 7.4.2.
My clients come from spain,portugal, latin america and germany (mainly).
The main feature of the site is a search engine that retrieves bibliographic data, which is stored in
my database (unicode!) with diacritical marks (e.g. Panamá,América); when users enter their search terms with diacritical marks postgres will find the requested records, but if a german user enter Panama or America (without diacritical marks), the search fails.
Is there any extension for postgres that allows for both modes of searching on the same data?

Yours,

Ralf Ullrich

______________________
Ralf Ullrich, M.A.
Virtuelle Fachbibliothek
Ibero-Amerikanisches Institut
Preußischer Kulturbesitz
Potsdamer Str. 37
D-10785 Berlin
Germany
Phone: +49 +30 266-2512
Fax: +49 +30 266-2503
E-Mail: ullrich(at)iai(dot)spk-berlin(dot)de
http://www.iai.spk-berlin.de
______________________

Attachment Content-Type Size
Ullrich Ralf.vcf text/x-vcard 139 bytes

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Eduardo Vázquez Rodríguez 2004-07-13 18:07:36 Query
Previous Message Bruno Wolff III 2004-07-13 11:43:01 Re: Weird join...