It seems we are both right :)
sqlite> create table test (filename varchar(1000) primary key);
sqlite> insert into test (filename) values ('test');
sqlite> select * from test where filename='test';
test
sqlite> select * from test where filename='tesT';
sqlite> select * from test where filename like 'tesT';
test
sqlite> insert into test (filename) values ('testing');
sqlite> select * from test where filename like 'tesT';
test
In other words, when doing field = 'value' it is case sensitive,
with a field like 'value' it isn't. If you don't use '%value%' it
will do an exact match (it seems).
This was tested on 3.2.1
----- Original Message -----
From: "Brandon, Nicholas" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Monday, December 05, 2005 12:15 PM
Subject: RE: [sqlite] Regarding String Comparision
Rob/Ritesh
Also keep in mind that such a search is CASE SENSITIVE.
There are two solutions to that, either makes the collation
case insensitive or do a:
I don't have access to SQLite immediately but I seem to remember in one of
my applications that the use of
select * from test where filename like '%file%';
would return string that are case INsensitive. (ie 'file', 'FILE', 'File'
...)
Ritesh I would suggest that you confirm this before relying on it.
Regards
Nick
********************************************************************
This email and any attachments are confidential to the intended
recipient and may also be privileged. If you are not the intended
recipient please delete it from your system and notify the sender.
You should not copy it or use it for any purpose nor disclose or
distribute its contents to any other person.
********************************************************************
