3. Best effort to preserve text  ... But if you insert the same invalid UTF-16LE content in a PRAGMA encoding=UTF8 database, the content must be converted into UTF8 when it is stored, which could cause irreversible changes to the content. Or if you insert that ... 

 ... INSERT INTO t1 VALUES(1, 'v2'); and the conflict resolution is REPLACE, then the INSERT change is removed from the local changeset (it was overridden). Or, if the conflict resolution was "OMIT", then the local changeset is modified to instead ... 

4.4.1. Contentless Tables  ... Contentless tables do not support REPLACE conflict handling. REPLACE and INSERT OR REPLACE statements are treated as regular INSERT statements. Rows may be deleted from a contentless table using an FTS5 delete command. Attempting to read any column value except ... 

5. Configurable Edit Distance  ... CREATE VIRTUAL TABLE demo2 USING spellfix1(edit_cost_table=APPCOST); The editdist3() edit-distance function can also be selected or deselected at run-time by inserting an appropriate string into the "command" column of the virtual table: INSERT INTO demo2(command) VALUES ... 

2.1. Row Value Comparisons  ... Any of the row values in the previous example could be replace by a subquery that returns three columns and the same answer would result. For example: CREATE TABLE t1(a,b,c); INSERT INTO t1(a,b,c) VALUES ... 

2.2.2. RBU Database Contents  ... INSERT with the same primary key values. It is not the same as an SQL REPLACE command, as in that case the new row may replace any conflicting rows (i.e. those that conflict due to UNIQUE constraints or indexes ... 

 ... IGNORE IMMEDIATE IN INDEX INDEXED INITIALLY INNER INSERT INSTEAD INTERSECT INTO IS ISNULL JOIN KEY LAST LEFT LIKE LIMIT MATCH MATERIALIZED NATURAL NO NOT NOTHING NOTNULL NULL NULLS OF OFFSET ON OR ORDER OTHERS OUTER OVER PARTITION PLAN PRAGMA PRECEDING ... 

4. Programming Loadable Extensions  ... gt; /* Do not use <sqlite3.h>! */ SQLITE_EXTENSION_INIT1 /* Insert your extension code here */ #ifdef _WIN32 __declspec(dllexport) #endif /* TODO: Change the entry point name so that "extension" is replaced by ** text derived from the shared library filename as follows ... 

 ... Using the two routines above, it is simple for applications to insert new records into or extract existing records from an SQLite Archive. Insert a new into an SQLite Archive using code like this: INSERT INTO sqlar(name,mode,mtime ... 

2.5. Statement Journal Files  ... UPDATE OR FAIL ... UPDATE OR IGNORE ... UPDATE OR REPLACE ... UPDATE OR ROLLBACK ... INSERT OR FAIL ... INSERT OR IGNORE ... INSERT OR REPLACE ... INSERT OR ROLLBACK ... REPLACE INTO .... The statement journal is given a randomized name, not necessarily in the same directory ...