Help Interpreting Classmark and sqlite BLOB storage

This is merely a historical archive of years 2008-2021, before the migration to mailman3.

A maintained and still updated list archive can be found at https://lists.osmocom.org/hyperkitty/list/OpenBSC@lists.osmocom.org/.

Holger Freyther holger at freyther.de
Fri Sep 9 13:49:58 UTC 2016


> On 09 Sep 2016, at 15:06, Keith Whyte <keith at 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


More information about the OpenBSC mailing list