You didn't mention what programming language and interface library you are using to access SQLite. My initial guess (based on very little information) is that the problem is in the interface to your programming language of choice, and not in SQLite itself. Can you provide complete code so that we can reproduce your problem and hence chase it to ground?