What does "i check for..." mean? We cannot possibly know what you are trying to do or implying even. Please show ALL the actual SQL calls that you do, both with what you expect the result should be, and what you are seeing. Also, which version of SQLite? Which OS? Alternatively, show any simple SQL script that any of us can run, which doesn't work, or fail, or return unexpected results, then we might be able to help.