Re: convert accented character to base character

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