Sounds like you're passing a non utf-8 encoded string from C# directly
to sqlite.
The easiest way I know of to check the actual data in the database is to
dump it as hex (i.e., select hex(column_name)) and check if the contents
are what you expect or not.
Gut feeling is that the strings in the database will be incorrect which
would mean that the problem is on the C# binding side. The problem is
most likely located where the C# strings are converted to C strings. I'm
not a C# user, but from the documentation it looks like you (or the
binding you're using) should be calling Encoding.UTF8.GetBytes(myString)
somewhere. Perhaps that's something you could check for in the code?
Pepijn
On 19-01-14 16:57, cinema cinema wrote:
I'm reading a text from c# saving it through a insert parameter in a
varchar column of a table. Both the file and the sqlite db encoding is
utf-8 but I see different characters (it seems due to a bad encoding) while
reading data from the sqlite3 command line or from other clients...
Any suggestion?
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users