portuguese characters

["jarek.nowotka@xxxxxxxxx" <jarek.nowotka@xxxxxxxxx>]

Hi,
I have a problem with some portuguese characters like:

select translate('programação', 'aszzclóençã ',
'aszzcloenca+');

i get:

WARNING:  ignoring unconvertible UTF-8 character 0xc3a3

and return is:

programaco

without 'a'

is this a problem with tabel encoding? or what? please help and
comment.

Jarek


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq