MySql cp1251 -> Jabber utf-8

Question

Python

Please tell me how can I encode the text in cp1251 from the database to utf-8 to send jabber?
I would be very grateful.

Answer 1

The casket just opened, I get the data in utf8 from the database, then after receiving the data str = unicode (string) the problem is that python did not know in what encoding I received the data.

Answer 2

thousands of them - ways. You need to change the encoding at the sending stage, i.e. during the work of some of your program, or do you want to convert directly in the database?

Answer 3

And what does, say, SQLyog show? I mean in text fields.
In general, you can convert a table using the ALTER TABLE CONVERT TO CHARACTER SET utf8;