Re: [sqlite] Selected string differs to Inserted one

2011-07-24 Thread Teg
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 exercis

Re: [sqlite] Selected string differs to Inserted one

2011-07-24 Thread Stephan Beal
On Sun, Jul 24, 2011 at 4:39 PM, Andrew Leeder wrote: > I have a table with a TEXT field that does not return the same string that > was inserted. The character that misbehaves is Greek letter "Ø". In fact > any character from the high end of the ANSII or ASCII table shows the > problem. > ASCI

[sqlite] Selected string differs to Inserted one

2011-07-24 Thread Andrew Leeder
Dear All I am very new to SQLite and am trying to convert a Windows Forms C#.NET (VS2010 SP1) application from an Access database to an SQLite one. All seems to have gone extremely well but I have come across one problem that has held me up for several days now. I have a table with a TE