First time here? Check out the Help page!
answered 2017-10-29 05:00:55 -0600
This is because strings retrieved from sqlite database are Unicode instead of UTF-8. Following changes should get rid of prefix u.
Unicode
UTF-8
u
conn = sqlite3.connect(sqlite_file) conn.text_factory = str c = conn.cursor()
Suggested readings: 1, 2, 3, 4