I have a problem where foreign characters get messed up when I write them to the database from .NET. Sample code made as simple as possible:
Dim cnn As New System.Data.SQLite.SQLiteConnection("test.db;UseUTF16Encoding=true")
Dim cmd As New System.Data.SQLite.SQLiteCommand("INSERT INTO test (test) VALUES ('Àlex')", cnn)
When I look at the table in SQLite Administrator, the field value shows as "Ã€lex". When I run the exact same query directly in SQLite Administratr, the field value shows correctly. What am I doing wrong?