portuguese characters
Started by jarek.nowotka@gmail.comover 20 years ago3 messagesgeneral
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
Re: portuguese characters
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