Seaching with and without diacritical marks - Mailing list pgsql-novice

From Ullrich Ralf
Subject Seaching with and without diacritical marks
Date
Msg-id 594F2B88520FB045BA370245CB19BBF06866EB@ExchangePK1.pk.de
Whole thread Raw
Responses Re: Seaching with and without diacritical marks
Re: Seaching with and without diacritical marks
List 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
diacriticalmarks postgres will find the requested records, but if a german user enter Panama or America (without
diacriticalmarks), 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@iai.spk-berlin.de
http://www.iai.spk-berlin.de
______________________



Attachment

pgsql-novice by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Weird join...
Next
From: Eduardo Vázquez Rodríguez
Date:
Subject: Query