Is is possible the character encoding is different?
On 4/30/2010 6:59 AM, Adam DeVita wrote:
> Is it possible there is a null, tab, newline or other invisible character?
> Try
>
> select timeStamp, 'yyyy' || resourceType || 'xxxxxx' From MyTable where
> resourceType like 'PSM' LIMIT 10;
>
> On Fri, Apr 30, 2010 at 9:53 AM, ecforu<ecforus...@gmail.com> wrote:
>
>
>> I don't think it is a case issue. See below from sqlite3 command line.
>> Also one thing to note - I build the database from c API. I don't know if
>> that makes a difference.
>>
>> sqlite>
>> sqlite> select timeStamp, resourceType From MyTable where resourceType like
>> 'PSM' LIMIT 10;
>> timeStamp|resourceType
>> 2010-04-28 17:46:45.316|PSM
>> 2010-04-28 17:46:49.854|PSM
>> 2010-04-28 17:46:52.830|PSM
>> 2010-04-28 17:47:04.939|PSM
>> 2010-04-28 17:47:06.776|PSM
>> 2010-04-28 17:47:08.846|PSM
>> 2010-04-28 17:47:12.001|PSM
>> 2010-04-28 17:47:13.845|PSM
>> 2010-04-28 17:47:16.837|PSM
>> 2010-04-28 17:47:18.846|PSM
>> sqlite>
>> sqlite>
>> sqlite> select timeStamp, resourceType From MyTable where resourceType =
>> 'PSM' LIMIT 10;
>> sqlite>
>> sqlite>
>> sqlite>
>>
>> THANKS
>>
>>
>> On Fri, Apr 30, 2010 at 9:35 AM, Black, Michael (IS)<
>> michael.bla...@ngc.com
>>
>>> wrote:
>>>
>>
>>> You are likely getting the case insensitive result with "like".
>>>
>>> sqlite> create table t(resourceType varchar);
>>> sqlite> insert into t values('PSM');
>>> sqlite> insert into t values('psm');
>>> sqlite> select * from t where resourceType = 'PSM';
>>> PSM
>>> sqlite> select * from t where resourceType like 'PSM';
>>> PSM
>>> psm
>>> sqlite> select * from t where upper(resourceType) = 'PSM';
>>> PSM
>>> psm
>>>
>>> Michael D. Black
>>> Senior Scientist
>>> Northrop Grumman Mission Systems
>>>
>>>
>>> ________________________________
>>>
>>> From: sqlite-users-boun...@sqlite.org on behalf of ecforu
>>> Sent: Fri 4/30/2010 8:31 AM
>>> To: General Discussion of SQLite Database
>>> Subject: Re: [sqlite] WHERE = does not work
>>>
>>>
>>>
>>> But the like WHERE clause works the way it is. Its the = that isn't
>>> working. I would rather use = than like. I'm just using like for now
>>> because it works.
>>>
>>> Thanks
>>>
>>> On Fri, Apr 30, 2010 at 9:29 AM, Timothy A. Sawyer<
>>> tsaw...@mybowlingdiary.com> wrote:
>>>
>>>
>>>> With the like clause you have to use the % sign as a wildcard. So
>>>> resourceType LIKE %'PSM' returns anything ending in PSM. The SQLite
>>>>
>>> website
>>>
>>>> has excellent docs on standard SQL.
>>>>
>>>> -----Original Message-----
>>>> From: ecforu<ecforus...@gmail.com>
>>>> Sent: Friday, April 30, 2010 09:22
>>>> To: sqlite-users@sqlite.org
>>>> Subject: [sqlite] WHERE = does not work
>>>>
>>>> I have an sqlite3 database which I can't query with WHERE =. I have to
>>>>
>>> use
>>>
>>>> WHERE like.
>>>>
>>>> Any ideas why this is?
>>>>
>>>> For example I have a resourceType column that has as some of its
>>>>
>> entries
>>
>>>> (over 50) 'PSM'.
>>>>
>>>> SELECT * FROM MyTable WHERE resourceType = 'PSM' --> returns nothing.
>>>>
>>>> SELECT * FROM MyTable WHERE resourceType like 'PSM' --> returns all PSM
>>>> entries.
>>>>
>>>> What's the diff?
>>>>
>>>> Thanks
>>>> _______________________________________________
>>>> 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
>>>
>>>
>>>
>>> _______________________________________________
>>> 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
