From: Andreas <maps.on@gmx.net>
To: pgsql-sql@postgresql.org
Subject: Is there a similarity-function that minds national charsets?
Date: Wed, 20 Jun 2012 18:30:39 +0200
Message-ID: <4FE1FAAF.3090004@gmx.net> (raw)
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?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: maps.on@gmx.net
Subject: Re: Is there a similarity-function that minds national charsets?
In-Reply-To: <4FE1FAAF.3090004@gmx.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox