On 5/6/05, robert rottermann <robert@redcor.ch> wrote:

Hi there, I have a problem using MySQLdb and unicode. with older version (0.92) I could set a parameter "unicode" to the connect() method to tell MySQLdb what charset to use.

This parameter is not accepted anymore. The only way to deal with non ascii character I found was setting pythons default charset to utf-8.

In 1.2, you can set use_unicode=True to tell it to return text-like columns as unicode objects. This uses whatever the current character set is on the connection. Prior to MySQL-4.1, there was no way to change the character set being used via the client without at least restarting the server. In 4.1 and newer, you can change this with a client configuration file or with SQL; I recommend using read_default_file. If you're not using ZMySQLDA, then this really isn't a Zope issue, and you should follow-up in the Help forum: https://sourceforge.net/forum/forum.php?forum_id=70461 -- Computer interfaces should never be made of meat. http://www.terrybisson.com/meat.html