SEO

#1 (**permalink**) 04-09-2008, 05:38 AM

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

#2 (**permalink**) 04-09-2008, 05:38 AM

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

#3 (**permalink**) 04-09-2008, 05:38 AM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode