Re: [sqlite] Sqlite+ICU library and usage of LIKE

[sreekumar . tp]

To conclude on this topic, I figured out the usage of '_' . 

--Original Message--
From: Igor Tandetnik
Sender: sqlite-users-boun...@sqlite.org
To: sqlite-users@sqlite.org
ReplyTo: General Discussion of SQLite Database
Subject: Re: [sqlite] Sqlite+ICU library and usage of LIKE
Sent: Sep 7, 2011 17:54

sreekumar...@gmail.com wrote:
> The _ operator( match any single char in the string) does not seem to work.. 
> % is ok..

Show your data and your statement. Explain what outcome you observe, and how it 
differs from your expectations.
-- 
Igor Tandetnik

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Sent from BlackBerry® on Airtel
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Sqlite+ICU library and usage of LIKE

[Igor Tandetnik]

sreekumar...@gmail.com wrote:
> The _ operator( match any single char in the string) does not seem to work.. 
> % is ok..

Show your data and your statement. Explain what outcome you observe, and how it 
differs from your expectations.
-- 
Igor Tandetnik

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Sqlite+ICU library and usage of LIKE

[sreekumar . tp]

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" 
Sender: sqlite-users-boun...@sqlite.org
Date: Tue, 6 Sep 2011 12:55:02 
To: 'General Discussion of SQLite Database'
Reply-To: General Discussion of SQLite Database 
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

Re: [sqlite] Sqlite+ICU library and usage of LIKE

[Michael Stephenson]

"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

Re: [sqlite] Sqlite+ICU library and usage of LIKE

[Sreekumar TP]

Some elementary issue in my code, works fine now.
Tks
-Sreekumar

2011/9/6 Sreekumar TP 

> I get the following error when I use % or _
>
> error @ 101, 1,1,unrecognized token: "'м"
>
>
>
> On Tue, Sep 6, 2011 at 9:21 PM, Igor Tandetnik wrote:
>
>> 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

Re: [sqlite] Sqlite+ICU library and usage of LIKE

[Sreekumar TP]

I get the following error when I use % or _

error @ 101, 1,1,unrecognized token: "'м"


On Tue, Sep 6, 2011 at 9:21 PM, Igor Tandetnik  wrote:

> 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

Re: [sqlite] Sqlite+ICU library and usage of LIKE

[Igor Tandetnik]

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