Python read database data, read out the Chinese garbled problem

Recently encountered Python read database data, read out the Chinese garbled problem,

The basic of Web search is:

"1. python file Set encoding utf-8 (file preceded by #encoding =utf-8)
2. mysql Database charset=utf-8
3. Python connection mysql is plus parameter Charset=utf8
4. Set Python's default encoding to Utf-8 (sys.setdefaultencoding (utf-8))

These are not resolved after one attempt. Go to the database to see the next, found that the Chinese garbled field type is varchar. And then think of the difference between varchar and nvarchar.

After use

SELECT CONVERT (nvarchar (100), field)

Translate the field to nvarchar, debug, find that the field in the Debug window is normal for Chinese.

Python read database data, read out the Chinese garbled problem