擅长:python、mysql、java
<p>Python3.7:</p>
<pre><code>con = sqlite3.connect(path_to_db)
encoding = "latin1"
con.text_factory = lambda x: str(x, encoding)
# do not preserve non-printable
# con.text_factory = lambda x: str(x, "ascii", errors="ignore")
data = pd.read_sql_query(QUERY, con)
</code></pre>
<p><a href="https://docs.python.org/2/library/sqlite3.html#sqlite3.Connection.text_factory" rel="nofollow noreferrer">Pydocs on text_factory</a></p>