Seaching with and without diacritical marks

Поиск
Список
Период
Сортировка
От Ullrich Ralf
Тема Seaching with and without diacritical marks
Дата
Msg-id 594F2B88520FB045BA370245CB19BBF06866EB@ExchangePK1.pk.de
обсуждение исходный текст
Ответы Re: Seaching with and without diacritical marks  (Mike G <mike@thegodshalls.com>)
Re: Seaching with and without diacritical marks  (Lynna Landstreet <lynna@gallery44.org>)
Список 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
______________________



Вложения

В списке pgsql-novice по дате отправления:

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: Weird join...
Следующее
От: Eduardo Vázquez Rodríguez
Дата:
Сообщение: Query