These options apply to all storage engines unless otherwise indicated.
Options that do not apply to a given storage engine may be accepted and remembered as part of the table definition.
In most cases, you do not have to specify any of them.Given a full 32-bit extended result code, the application can always find the corresponding primary result code merely by extracting the least significant 8 bits of the extended result code. Hence the terms "extended result code" and "extended error code" are interchangeable.For historic compatibility, the C-language interfaces return primary result codes by default.The extended result code for the most recent error can be retrieved using the sqlite3_extended_errcode() interface.The sqlite3_extended_result_codes() interface can be used to put a database connection into a mode where it returns the extended result codes instead of the primary result codes. Symbolic names for all result codes are created using "#define" macros in the sqlite3.h header file.