On 9/6/2011 11:41 AM, Sreekumar TP wrote:
If I modify the statement to return all strings which match 'м' , No strings are fetched.zSQL = sqlite3_snprintf(1024,temp2,"SELECT * FROM l1 WHERE data LIKE 'м' ;");
You probably want LIKE 'м%'. It's rather pointless to use a LIKE operator with no wildcards.
-- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
