Thread: portuguese characters

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

sorry for posting that, i already found anwser. but i wonder if client
encoding will be enought to make changes i want to..

ok, i already know that it's a table encoding problem. created new one
with unicode and i worked just fine. but i have another problem. how
can i change encoding in database which is already created?

Jarek