SQLite driver fails to insert TEXT into longblob column #268
Description
When running the Wordfence installation SQL script on SQLite, the INSERT statement for the wp_wfconfig table fails with the following error:
WP_SQLite_Driver_Exception: SQLSTATE[23000]: Integrity constraint violation: 19 cannot store TEXT value in BLOB column wp_wfconfig.val
The issue occurs because the table defines val as longblob, but the insert statement provides a TEXT value ('2'). SQLite enforces strict typing and disallows implicit TEXT-to-BLOB conversion.