I know this issue has been brought up many times and I have tried to search and read as much as possible but still have not been able to resolve my issue. I have a mysql database (not the latest but it supports unicode). I am keeping some columns in utf8 format and only save data that is in utf8. However, when I read the data back (I am using mod_python and mysqldb module) I see characters like the following on my web page: %u0631 Now if I replace "%u" with "&#x" in my python code b/f sending them to browser, everything displays fine! Am I doing something wrong in mysql side? I have just defined the encoding for the columns I want to utf8. Is there anything else I have do in MySQL to get the data from tables in the right format that is displaybed in the broswer (I set the character set to utf-8 by Apache in my http headers). I have tried many different things (including setting client or connection character set) but have not been able so far to get the data back the way I want from mysql. Or, is this the job of the python to do the conversion. I appreciate any help. -Jalil
