wwarby
asked on
European characters garbled when inserted using SQLite for .NET
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.SQLiteC onnection( "test.db;U seUTF16Enc oding=true ")
cnn.Open()
Dim cmd As New System.Data.SQLite.SQLiteC ommand("IN SERT INTO test (test) VALUES ('Àlex')", cnn)
cmd.ExecuteNonQuery()
Result:
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?
Dim cnn As New System.Data.SQLite.SQLiteC
cnn.Open()
Dim cmd As New System.Data.SQLite.SQLiteC
cmd.ExecuteNonQuery()
Result:
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER