Troubleshooting Python String handling error Unicodedecodeerror: ' ASCII ' codec can ' t decode byte 0xe4 in position 108:ordinal not in range (128)

Today to do the curriculum design encountered with the database interaction, the SQLite database is set to UTF-8 format encoding, inserted into the database is correct, but when read out of the error, the reason is that Python str default is ASCII encoding, collect online data, many times to try, The problem is solved, add the following sentence in the code:

Import sysreload (SYS) sys.setdefaultencoding ('UTF8')

Troubleshooting Python String handling error Unicodedecodeerror: ' ASCII ' codec can ' t decode byte 0xe4 in position 108:ordinal not in range (128)