I'm trying to execute the following command:
db.Query<People>("Update People set FirstName='Sérgio' WHERE PeopleID = 2")
Where db is my SQLiteConnection object (provided by SQLite.WinRT). I'm using SQLiteStudio to manage my .db file. When I update "FirstName" field using SQLiteStudio, it works fine. But when I do it by app, it turns into "S�rgio".
I already checked database PRAGMA, which is UTF-8.
The error seems to be between app and database. Any guesses how to solve it?
Aucun commentaire:
Enregistrer un commentaire