I think that your MYSQLdb python library doesn’t know it’s supposed to encode to utf8, and is encoding to the default python system-defined charset latin1
.
When you connect()
to your database, pass the charset="utf8"
parameter. This should also make a manual SET NAMES
or SET character_set_client
unnecessary.