Re: Seaching with and without diacritical marks
От | Mike G |
---|---|
Тема | Re: Seaching with and without diacritical marks |
Дата | |
Msg-id | 20040714014521.GC3003@localhost.localdomain обсуждение исходный текст |
Ответ на | Seaching with and without diacritical marks ("Ullrich Ralf" <Ullrich@iai.spk-berlin.de>) |
Список | pgsql-novice |
Automatically I don't believe so. You can modify your queries though. IF default search returns 0 records then SET CLIENT_ENCODING TO 'some_other_encodin'; SELECT..... END IF; Maybe search for those special characters before issuing a SELECT statement. HTH. On Tue, Jul 13, 2004 at 02:20:48PM +0200, Ullrich Ralf wrote: > 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 > ______________________ > > Content-Description: Ullrich Ralf.vcf > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings
В списке pgsql-novice по дате отправления: