mercredi 2 septembre 2015

Losing char when inserting/updating data at SQLite with C#

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