Re: [sqlite] Syntax sanity question...

2008-10-01 Thread Mark Spiegel
Thank you. Yes, I've seen how the 16 bit versions just pass through to the 8 bit versions. Living in a UNICODE world... Looking at the source, this define is only used in test_config.c and mkkeywordhash.c. I didn't discover mkkeywordhash.c originally. Just to improve my ability to navigate

Re: [sqlite] Syntax sanity question...

2008-10-01 Thread D. Richard Hipp
On Oct 1, 2008, at 6:25 PM, Mark Spiegel wrote: > -DSQLITE_OMIT_CONFLICT_CLAUSE=1 This disables REPLACE. Also, just so you will know, sqlite3_prepare16() works by converting the SQL into UTF8 then calling sqlite3_prepare(). D. Richard Hipp [EMAIL PROTECTED]

[sqlite] Syntax sanity question...

2008-10-01 Thread Mark Spiegel
Doing some experimenting in my application and having trouble with an "INSERT OR REPLACE" statement. SQLite version 3.5.9 Table schema: CREATE TABLE DDS (FileId INTEGER PRIMARY KEY, _ModTime INTEGER, _CreTime INTEGER , _vtresult INTEGER, _md5 BINARY, _sha1 BINARY, _sha256 BINARY, _StabString_