SQLite3 Chinese encoding Python implementation,

SQLite3 Chinese encoding Python implementation,

Reading more than 100,000 pieces of text is written to the SQLite database. Because the text contains Chinese characters, it is correct to insert it into the database. It is always a UnicodeDecodeError during retrieval, resulting in a hard day.

The final solution is as follows:

When Python connects data, perform the following settings:

Db = sqlite3.connection ("...")

Db. text_factory = st

In addition, the hard-coded Chinese strings in the python Code do not have any problems, except that

#-*-Coding: UTF-8 -*-

Set the python source code to UTF-8

Import sys

Reload (sys)

Sys. setdefaultencode ('utf8 ')

The implementation of the above SQLite3 Chinese code Python is all the content that I have shared with you. I hope to give you a reference and support for the help house.