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
______________________