Hello Andrew, I convert all my strings the UTF-8 before insert or selecting. You probably need to look into something like that too. Filenames for the DB files have to be UTF-8 too or you'll have problems opening files sometimes.
My test folder has an umlaut in the path so, this code gets exercised every time I run my program. C Sunday, July 24, 2011, 10:39:51 AM, you wrote: AL> Dear All AL> AL> I am very new to SQLite and am trying to convert a Windows Forms AL> C#.NET (VS2010 SP1) application from an Access database to an AL> SQLite one. All seems to have gone extremely well but I have come AL> across one problem that has held me up for several days now. AL> AL> I have a table with a TEXT field that does not return the same AL> string that was inserted. The character that misbehaves is Greek AL> letter "Ø". In fact any character from the high end of the ANSII AL> or ASCII table shows the problem. AL> AL> Since I have done nothing special in creating the database I AL> believe it is encoded UTF-8 by default. I assume that my inserted AL> string is similarly encoded UTF-8 since I have done nothing AL> special in my C# code to change this. The data in the database AL> seems to be correct since the SQLite Administrator program correctly displays the data. AL> AL> Why does the Selected data come back wrong, and how can I correct AL> this. Clearly this is a bit of a non-problem otherwise every AL> other .NET user would be screaming but I have searched for several AL> days now without finding a solution. AL> AL> Can anyone help me please? AL> Thanks in advance AL> ~A AL> Andrew Leeder AL> AL> . AL> AL> _______________________________________________ AL> sqlite-users mailing list AL> sqlite-users@sqlite.org AL> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Best regards, Teg mailto:t...@djii.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
