Internationalisation: SELECT str (ignoring Umlauts/Accents)

Поиск
Список
Период
Сортировка
От Benedikt Eric Heinen
Тема Internationalisation: SELECT str (ignoring Umlauts/Accents)
Дата
Msg-id Pine.LNX.3.96.980617084805.29875A-100000@fenun.icemark.ch
обсуждение исходный текст
Ответы Re: [SQL] Internationalisation: SELECT str (ignoring Umlauts/Accents)
Список pgsql-sql
Hi there,


  has anyone done a good implementation of a search algorithm, that would
allow searching for a string, with automatic use of alternate forms for
Umlauts ('ae' in a search string matches the a-Umlaut ), or allowing to
search without knowing the correct accents ( 'a' in a search string also
matches 'à', 'e' also matches 'é', ... )?

  This should - of course - work one-way only, i.e. if a string in the
database contains "ae" and the search string contains the German a-Umlaut,
then the string containing ae should not be matched, while the other way
around it should.



  Ideas anyone?


      Benedikt

Windows 95: n.
    32-bit extensions and a graphical shell for a 16-bit patch to an 8-bit
    operating system originally coded for a 4-bit microprocessor,  written
         by a 2-bit company that can't stand for 1 bit of competition.


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

Предыдущее
От: Dim Zegebart
Дата:
Сообщение: Re: [SQL] psql
Следующее
От: "Andreas Fredriksson"
Дата:
Сообщение: subscribe pgsql-sql