On 09 Sep 2016, at 15:06, Keith Whyte
<keith(a)rhizomatica.org> wrote:
BTW, I get that the BLOBs in sqlite are somehow encoded, (if that is not
completely the wrong term to use) as hex_value-1, I've also noted this
in the SMS table when trying to identify an sms in the sms_queue. So
question part 2: what is that about?
Is there an easy way I could "decode" on the command line, as in:
echo "SELECT user_data FROM sms limit 1;" | sqlite3
/var/lib/osmocom/hlr.sqlite3 | some magic to display readable SMS content
Right libdbi has encoding for "blob". tnt has written a _dbi_binary_quote in
python in pysim. It might help you to write the unquote.
holger