> Subject: Having trouble using sqlite to handle query that contains Chinese > characters > > Dear Sir: > > I was working on a windows 8 app, which involve using SQLite database. I > downloaded .dll from your website. I have some trouble when using sqlite to > handle query that contains Chinese characters. > > When I debug the code, the strSQL variable looks correct to me. > > SQLite.SQLiteAsyncConnection _dbConnection = new > SQLite.SQLiteAsyncConnection(_dbPath); > ObservableCollection<SearchResult> result = new > ObservableCollection<SearchResult>(); > ... > result = new ObservableCollection<SearchResult>(await > _dbConnection.QueryAsync<SearchResult>(strSQL)) > > It seemed to me that the query I was trying to run eventually became the > following based on the result returned. > select column1, column2 from table where columnx like ‘%?%’ > > where “?” is where the chinese character should have been. I had no problem > getting Chinese characters from the database if the where clause doesn’t > contain any chinese character. > > I run the same query in “SQLite Expert personal version” and I was able to > see the correct result returned. > > So what can I do to get this problem fixed? Do you have any suggestion? > > Thanks very much! > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
