Unicode and unaccent()

I am trying to write an unaccent function because I need to do some queries comparing data that has accents and data that does not.

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 have tried and failed to get this working using the what I think is the Unicode escaping method \u0032 for example.

Even if someone could help me with the Unicode escaping method that would be useful.  For example if I wanted to find a Unicode character 0x00E2 with a select statement how would I?

Something like select * from table where field like ‘%\u00e2%’;

Doesn’t seem to work.

Does anyone have a good method for unaccenting Unicode dbs/characters?

I am using PG7.4 on FC2

Thank you