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] -----------------------------------------------------------------------------