"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

Reply via email to