On 28/06/10 17:22, Neubert Joachim wrote:
>
> I want to convert accented characters to the according base character,
> e.g. "Ü" or "Ú" to "U".
>
I have the following:
CREATE OR REPLACE FUNCTION unaccent(TEXT) RETURNS TEXT AS
$$
use Text::Unaccent;
return unac_string('UTF8', $_[0]);
$$ LANGUAGE plperlu IMMUTABLE STRICT;
On debian you need the following package:
libtext-unaccent-perl
Kind regards,
Mathieu