Re: [sqlite] sqlite-users Digest, Vol 39, Issue 13

Not sure why you are using a subselect with a union all. Try this: SELECT * FROM multiturnTable WHERE (player1 ='?' OR player2 ='?') AND (complete=0 OR p1SubmitScore=0 OR p2SubmitScore=0) AND p1Declined=0 AND p2Declined=0 > > Message: 1 > Date: Sun, 13 Mar 2011 11:43:30 +

[sqlite] Will CEROD work with the new BerkleyDB implementation?

Will CEROD work with the new BerkleyDB implementation? -- Garry Watkins Managing Director DynaFOCUS, LLC ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] apple-osx branch

What is the apple-osx branch? Is it usable on the iphone? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] What encoding format is used in the FTS3 tokenizer? and other tokenizer questions.

I am writing a FTS3 tokenizer that works with iPhoneOS using Apple's CoreFoundation library. What encoding is used on inbound insert statements into a FTS3 virtual table? For example I have Japanese text encoded as UTF-8 and passed in as UTF-8 insert statement is encoded as UTF-8. I am