The _ operator( match any single char in the string) does not seem to work.. % is ok..
Any clue? Sent from BlackBerry® on Airtel -----Original Message----- From: "Michael Stephenson" <domehead...@gmail.com> Sender: sqlite-users-boun...@sqlite.org Date: Tue, 6 Sep 2011 12:55:02 To: 'General Discussion of SQLite Database'<sqlite-users@sqlite.org> Reply-To: General Discussion of SQLite Database <sqlite-users@sqlite.org> Subject: Re: [sqlite] Sqlite+ICU library and usage of LIKE "It's rather pointless to use a LIKE operator with no wildcards." Except that it performs a case-insensitive comparison, so a quick-and-dirty way to accomplish that. -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Tandetnik Sent: Tuesday, September 06, 2011 11:52 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Sqlite+ICU library and usage of LIKE 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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
