Dear Pepijn, thank you very much for your answer, you are saying a lot of right things. I believe that your most important suggestion is to use the hex function. I didn't know this sqlite command andI I will try it soon.
In the meantime I solved my problem Jand I wrote a post also here: http://stackoverflow.com/questions/21219600/sqlite-encoding-from-net If you are also a SO user and you want to reply there, I'll be happy to mark this as answered. case Note that initially I started addind those encoding lines in c# ... And finally I realised that the problem was not there :-) I suspect that for the sqlite mailinglist it is offtopic adding a comment about sqliteadmin showing text in ansi and not in unicode... In any case also the sqlite3 is showing text against windows codepage cmd... :-) Had I used the select hex, maybe I would have easily understood that my vanilla c# string insert was correctly writing a utf-8 sequence of c2 a0 to represent the non breaking space -- View this message in context: http://sqlite.1065341.n5.nabble.com/Sqlie-from-c-encoding-bug-tp73339p73371.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
