Is there a similarity-function that minds national charsets? - Mailing list pgsql-sql

From Andreas
Subject Is there a similarity-function that minds national charsets?
Date
Msg-id 4FE1FAAF.3090004@gmx.net
Whole thread Raw
Responses Re: Is there a similarity-function that minds national charsets?  (Craig Ringer <ringerc@ringerc.id.au>)
List pgsql-sql
Hi,

Is there a similarity-function that minds national charsets?

Over here we've got some special cases that screw up the results on 
similarity().

Our characters: ä, ö, ü, ß
could as well be written as:  ae, oe, ue, ss

e.g.

select similarity ( 'Müller', 'Mueller' )
results to:  0.363636

In normal cases everything below 0.5 would be to far apart to be 
considered a match.

As it is, I had to transfer the contents of the table into a temporary 
table where I translate every ambigous char to it's 2 char representation.

Is there a solution so that detour is not necessary?


pgsql-sql by date:

Previous
From: Emi Lu
Date:
Subject: Simple method to format a string
Next
From: Wes James
Date:
Subject: Re: Simple method to format a string