HRESULT 0x87AF0014 (SQLITE_E_MISMATCH): meaning and diagnosis

Status / error code:

Category:

Constant name:

Source:

Facility:

Operating System:

Description:

SQLite found a data-type mismatch in the requested operation.

Previous	Next
SQLITE_E_CONSTRAINT	SQLITE_E_MISUSE

SQLITE_E_MISMATCH

SQLITE_E_MISMATCH corresponds to SQLite SQLITE_MISMATCH. The SQL operation required a value of a different type or representation than the one supplied.

What to check

Log the SQL statement, parameter types, and relevant schema declarations, not only their textual values.
Check application serialization and binding APIs; binding text where a BLOB or integer is expected can produce different behavior from a literal SQL value.
Correct the data contract or conversion path instead of relying on implicit conversions to mask malformed input.

SELECT typeof(?1);

SQLite: Result and Error Codes

Looking for a different code? Search another status or error code.