Having problem while showing UTF8 data from MySQL using Python

[Rozita Raissi]

Hi everybody,

I have set encoding of my MySQL server to "utf8". I've created a table named as "user" which has "first_name" and "last_name" columns. I've set encoding of table and these two columns to "utf8" too.

I entered some Farsi data in the table manualy. Then I wrote a Python program to show list of all users. My python program shows "?" instead of each farsi character. What can I do to show real Farsi characters?

Also I wrote another program to insert some data into the table. When I enter Farsi characters, it stores each Farsi character as a unicode character whoes length is more than one character. But I want to insert each farsi character as only one character not more.

Please help me.

Regards,
Rozita