Python operation MySQL garbled problem solved

When using Python's MySQLdb module to connect and operate MySQL, when the query is not found in Chinese, when inserting data is garbled. It's a headache. The final solution is as follows:

conn = MySQLdb.connect (...) cur = conn.cursor () cur.execute ("Set NAMES UTF8;") Cur.execute ("Set CHARACTER set UTF8;") Cur.execute ("Set character_set_ Connection=utf8; ") Cur.execute (' ... ') conn.commit ()

This is a relatively perfect solution to the problem.

Python operation MySQL garbled problem solved