Revision history  [back]

This is because strings retrieved from sqlite database are Unicode instead of UTF-8. Following changes should get rid of prefix u.

conn = sqlite3.connect(sqlite_file)
conn.text_factory = str
c = conn.cursor()

Suggested readings: 1, 2, 3, 4