SQLAlchemy, MySQL and UTF-8
While SQLAlchemy uses UTF-8 by default, the charset used when communicating with MySQL will affect the encoding of the returned data. To be sure that everything is handled properly as UTF-8 (which you might use
SET NAMES 'utf8' in the console (don’t do that here..)), add ?charset=utf8 to your connection url:
Thanks to RustyFluff at StackOverflow.