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