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 |
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... |