Nothing you've mentioned is out of the ordinary. I would expect the
same behavior on both platforms.
Can you post the complete schema, and the exact query that exhibits the
problem? (And perhaps a couple of insert statements into the objects table).
Without this I don't think anyone can recreate the problem.
--- Brett Keating <[EMAIL PROTECTED]> wrote:
> 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.
____________________________________________________________________________________Got
a little couch potato?
Check out fun summer activities for kids.
http://search.yahoo.com/search?fr=oni_on_mail&p=summer+activities+for+kids&cs=bz
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
