Re: [sqlite] (BUG?) sqlite3_bind_blob oops, not exactly a bug

2017-03-12 Thread Dominique Devienne
> > If you use sqlite3_bind_blob on insert and select, it will successfully > find the > test row. Only mixing sqlite3_bind_blob, and sqlite3_bind_text causes these > mysterious failures. Does sqlite3_bind_text... encode it to UTF-16 or > something? > > This is still a (moderately) huge problem

[sqlite] (BUG?) sqlite3_bind_blob oops, not exactly a bug

2017-03-12 Thread sqlite
Darn it! Sorry! I forgot to reset my prepared select statement. My whole example was screwed up. The actual behavior is at least sensible-ish, but still not quite right. If you use sqlite3_bind_blob on insert and select, it will successfully find the test row. Only mixing sqlite3_bind_blob, and