MySQL for HLR

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/.

Kang-min Liu gugod at gugod.org
Fri Mar 2 17:36:41 UTC 2012


On 2012/3/2, at 下午4:50, Alexander Huemer wrote:
> 
> I remember that somebody stumbled over a weirdness in the way the data
> is actually stored in the DB (sqlite), which was caused by the DBI
> layer.

That would be me. To recap: libdbi (c lib) store binary value in its own way.

It escapes the value to make it fit in a SQL string, instead of sqlite3_bind_blob
function to store the actual raw value. It bugged me because I was trying to read
the db from a perl program. I ended up porting the escaping/unescaping subroutine to perl
in order to read/write the SMS table.

Sincerely,
Kang-min Liu





More information about the OpenBSC mailing list