Re: Unicode and unaccent()

    Mark Borins wrote:

> The encoding on my DB is Unicode, so far I have found an unaccent() function
> by looking in the mail archives it looks like the following:
>
>
> CREATE FUNCTION unaccent(text) RETURNS text AS $$
>    BEGIN
>        RETURN translate($1, '\342\347\350\351\352\364\373', 'aceeeou')
>  ;  END;  $$ LANGUAGE plpgsql IMMUTABLE STRICT;
>
> My problem is that the values like \342 are for LATIN1 type encoding.  I

Why wouldn't this:
   RETURN translate($1, 'éçàêè...', 'ecaee...') ;
work just fine? It's even portable across encodings.

--
 Daniel
 PostgreSQL-powered mail user agent and storage: http://www.manitou-mail.org