Just for kicks, what happens on both platforms when you issue:
select genre, length(genre), hex(genre), filename
from objects where media_type=1;
as well as:
select count(*) from objects where genre LIKE '%POP%';
> I have a bizarre problem. Here is an example of something I tried in
> sqlite3 3.3.8:
>
> sqlite> select genre,filename from objects where media_type=1;
> ....query abbreviated...
> Msica independiente|0056_People Get Ready1_test1.wma
> POP|0057_The Mighty Ship1_test1.wma
> POP|0058_The Mighty Quinn1_test1.wma
> ....query abbreviated...
> sqlite> select genre,filename from objects where genre='POP';
> sqlite>
>
> So basically, no results are returned from the second query although
> clearly there are items in the list with genre='POP'.
>
> This problem only happens on Linux. On Windows, the query returns the
> results as expected... Which makes it yet more bizarre.
____________________________________________________________________________________Get
the Yahoo! toolbar and be alerted to new email wherever you're surfing.
http://new.toolbar.yahoo.com/toolbar/features/mail/index.php
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
