search

rogerbinns / apsw

Another Python SQLite wrapper
https://rogerbinns.github.io/apsw/
Other
715 stars 96 forks source link

con.pragma can't accept blobs #523

Closed rogerbinns closed 1 month ago

rogerbinns commented 1 month ago

If you do pragma abc = x'1234' then you get a syntax error at the x. Connection.pragma currently encodes binary that way.

The two choices are either to reject the value, or to wrap the blob value in double quotes so it becomes pragma abc = "x'1234'".

The latter is what SLite3 Multiple Ciphers expects. SEE uses a separate pragma hexkey.

rogerbinns commented 1 month ago

Not going to fix. SQLite might accept blobs in the future, so doing magic conversion now won't help.