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

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 S

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

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 ___

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

ssion 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

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

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 >

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

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: >> >>> I

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

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. >> >> zS

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 n

[sqlite] Sqlite+ICU library and usage of LIKE

Hi, I am using ICU library to collate and pattern match strings in Russian language. I use C api to intialise the icu library . sqlite3IcuInit(db); zSQL = sqlite3_snprintf(1024,temp1,"SELECT icu_load_collation('ru_RU', 'RUSSIAN');"); sqlite3_prepare_v2(db,(const char *)zSQL,-1,&CollationStmt, NUL