[sqlalchemy] unicode in where clause on mysql

2012-07-18 Thread Cornelius Kölbel
Hi there, I am trying to do a select on a table, where a user has a /username/ with a German umlaut like kölbel. The table in the mysql-database is utf-8. I also failed when the table was latin1. My problem is that by no(!) chance I manage to match the user and get a row from the select

Re: [sqlalchemy] unicode in where clause on mysql

2012-07-18 Thread Michael Bayer
easiest way here would be to specify use_unicode=1charset=utf8 with the MySQL connection string, so that your MySQLdb DBAPI handles incoming unicode objects correctly. http://docs.sqlalchemy.org/en/rel_0_7/dialects/mysql.html#unicode On Jul 18, 2012, at 7:45 AM, Cornelius Kölbel wrote: Hi