[sqlalchemy] Unicode problem with MySQL-Table with collation utf8_bin and utf8_general_ci

2010-12-09 Thread Marko Krause
Hello, I have a problem with sqlalchemy 5.8 and mysql 5.1. I have a table with a text-column, which has the collation utf8_general_ci. When I access the table sqlalchemy returns a Unicode, as it was expected. But when I change the collation of the column to utf8_bin, sqlalchemy returns an

Re: [sqlalchemy] Unicode problem with MySQL-Table with collation utf8_bin and utf8_general_ci

2010-12-09 Thread Michael Bayer
specify use_unicode=0 on your MySQL engine. SQLAlchemy will perform the utf-8 decode instead. On Dec 9, 2010, at 6:56 AM, Marko Krause wrote: Hello, I have a problem with sqlalchemy 5.8 and mysql 5.1. I have a table with a text-column, which has the collation utf8_general_ci. When I