> On 09 Sep 2016, at 15:06, Keith Whyte <[email protected]> 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
