cyMax - 2007-02-11

Hi,
I've got problems on my Windows box with UTF-8, like some other people :
It was impossible to change the charset with "set_character_set('utf8')", whatever the MySQL version (v4, v5), the MySQL configuration, using a 'cnf' file or not, etc. (cf. http://sourceforge.net/forum/message.php?msg_id=3982782)
"character_set_name()" was always returrning "latin1" ...
I've searched on the forum for answers and tried every trick I found, but nothing worked.

Then i read the thread about Python 2.5 (http://sourceforge.net/forum/forum.php?thread_id=1571110&forum_id=70461) and found the 1.2.2_p2 binaries compiled for Windows and Python 2.5 (http://sourceforge.net/forum/message.php?msg_id=4097242), so I decided to try it, and guess what ? It worked : now i can change the charset with "set_character_set('utf8')" and "character_set_name()" returns correctly 'utf8'.

My guess is that maybe the 1.2.1_p2 binaries for Windows/Python 2.4 are not compiled correcly, regarding this message : http://sourceforge.net/forum/message.php?msg_id=4059722
Jeong-Min Lee (thanks to him !) compiled the 1.2.2_p2 against MySQL 5.0.24a (i'm runing MySQL community 5.0.21)
Unfortunately, I cannot compile MySQLdb myself because I don't have Visual C++ 2005, I just have the Express version.

Hope this helps.