Matthew Veenstra <[EMAIL PROTECTED]> wrote: > My SQL Statement is a standard null terminated C string (UTF-8 > format). The termination is at the proper place. strlen() verifies > this. > > Is the string supposed to be something else than a C string? > > What is really odd is that it works perfectly with the installed > 3.1.3. With the same string. >
The 3rd parameter to sqlite3_prepare() is probably wrong. There was a bug (ticket #1650, http://www.sqlite.org/cvstrac/tktview?tn=1650) that caused the 3rd parameter to be ignored in version 3.1.3, so if you got it wrong it would still work for a null-terminated string in version 3.1.3. Since the bug has been fixed, the 3rd parameter to sqlite3_prepare() needs to be -1 if the SQL is a null-terminated string. -- D. Richard Hipp <[EMAIL PROTECTED]>
