SQLAlchemy solution programmingerror:you must not use 8-bit bytestrings unless your use a text_factory

SQLAlchemy newspaper programmingerror:you must not use 8-bit bytestrings unless you use a text_factory the can interpret 8-bit by Testrings Error

python2.x The most annoying is the coding problem, write down for later use.

Workaround:

1. At the beginning add:

#encoding: Utf-8

2. Try Convert characters to Unicode format

Unicode (Str_name)

This method sometimes appears: "Unicodedecodeerror: ' ASCII ' codec can ' t decode byte 0xe5 in position 108:ordinal not in range (128 ...") This problem.

Workaround:

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

SQLAlchemy solution programmingerror:you must not use 8-bit bytestrings unless your use a text_factory