Internationalisation: SELECT str (ignoring Umlauts/Accents) - Mailing list pgsql-sql

From Benedikt Eric Heinen
Subject Internationalisation: SELECT str (ignoring Umlauts/Accents)
Date
Msg-id Pine.LNX.3.96.980617084805.29875A-100000@fenun.icemark.ch
Whole thread Raw
Responses Re: [SQL] Internationalisation: SELECT str (ignoring Umlauts/Accents)  (Patrice Hédé <patrice@idf.net>)
List 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 by date:

Previous
From: Dim Zegebart
Date:
Subject: Re: [SQL] psql
Next
From: "Andreas Fredriksson"
Date:
Subject: subscribe pgsql-sql